How To Rename An Existing Column In A Table

How To Rename An Existing Column In A Table


  • 15 Mar, 2012

    If you have an existing column in a table and you want to change the column name, you can use the "ALTER TABLE ... CHANGE" statement. This statement allows you to change the name of a column, and its definition. The tutorial script below gives you a good example:mysql> ALTER TABLE tip CHANGE COLUMN subject title VARCHAR(60);Query OK, 1 row affected (0.51 sec)Records: 1 Duplicates: 0 Warnings: 0mysql> SHOW COLUMNS FROM tip;+-------------+--------------+------+-----+---------+-------| Field | Type | Null | Key | Default | Extra +-------------+--------------+------+-----+---------+-------| id | int(11) | NO | PRI | | | title | varchar(60) | YES | | NULL | | description | varchar(256) | NO | | | | author | varchar(40) | YES | | NULL | +-------------+--------------+------+-----+---------+-------4 rows in set (0.02 sec)

    Comments Received:
    Please give your suggestions and feedback:

2009-2016 downloadmela.com. All rights reserved.