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, 1632🔥, 0💬
Popular Posts:
How to download Microsoft SQL Server 2005 Express Edition in SQL Server? Microsoft SQL Server 2005 E...
How To Convert Character Strings into Numeric Values in SQL Server Transact-SQL? Sometimes you need ...
What Happens If the Imported Table Already Exists in Oracle? If the import process tries to import a...
What Happens to Your Transactions When ERROR 1213 Occurred in MySQL? If your transaction receives th...
Where to find answers to frequently asked questions on INSERT, UPDATE and DELETE Statements in MySQL...