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, 1634🔥, 0💬
Popular Posts:
How To Convert a Unicode Strings to Non-Unicode Strings in SQL Server Transact-SQL? Since Unicode ch...
How To Find Out What Privileges a User Currently Has in Oracle? Privileges granted to users are list...
How To Connect ASP Pages to Oracle Servers in Oracle? If you are running Windows IIS Web server and ...
How To Insert New Line Characters into Strings in SQL Server Transact-SQL? If you want to break a st...
How to change the data type of an existing column with "ALTER TABLE" statements in SQL Server? Somet...