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, 1671🔥, 0💬
Popular Posts:
Where to find answers to frequently asked questions on Managing Security, Login and User in SQL Serv...
How To Start Instance with a Minimal Initialization Parameter File in Oracle? The sample initializat...
How To List All User Names in a Database in SQL Server? If you want to see a list of all user names ...
What Is Oracle in Oracle? Oracle is a company. Oracle is also a database server, which manages data ...
How To Use DATEADD() Function in SQL Server Transact-SQL? DATEADD() is a very useful function for ma...