Collections:
Rename an Existing Column in a Table in MySQL
How To Rename an Existing Column in a Table in MySQL?
✍: FYIcenter.com
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: 0 mysql> 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)
⇒ Rename an Existing Table in MySQL
⇐ Delete an Existing Column in a Table in MySQL
2018-03-04, 1396👍, 0💬
Popular Posts:
Where to find answers to frequently asked questions on Introduction to Date and Time Handling in MyS...
How to change the data type of an existing column with "ALTER TABLE" statements in SQL Server? Somet...
How To Drop an Index in Oracle? If you don't need an existing index any more, you should delete it w...
How To Start Instance with a Minimal Initialization Parameter File in Oracle? The sample initializat...
How To Format Time Zone in +/-hh:mm Format in SQL Server Transact-SQL? From the previous tutorial, y...