Collections:
Rename an Existing Table in MySQL
How To Rename an Existing Table in MySQL?
✍: FYIcenter.com
If you want to rename an existing table, you can use the "ALTER TABLE ... RENAME TO" statement. The tutorial script below shows you a good example:
mysql> ALTER TABLE tip RENAME TO faq; Query OK, 0 rows affected (0.01 sec) mysql> SELECT * FROM faq; +----+-------------+-------------------------+--------+ | id | title | description | author | +----+-------------+-------------------------+--------+ | 1 | Learn MySQL | Visit dev.fyicenter.com | NULL | +----+-------------+-------------------------+--------+ 1 row in set (0.00 sec)
⇒ Drop an Existing Table in MySQL
⇐ Rename an Existing Column in a Table in MySQL
2018-02-14, 1314🔥, 0💬
Popular Posts:
What Happens to Your Transactions When ERROR 1213 Occurred in MySQL? If your transaction receives th...
How To Verify a User name with SQLCMD Tool in SQL Server? The quickest way to verify a user name in ...
How to connect SQL Server Management Studio Express to SQL Server 2005 Express in SQL Server? Once y...
How To Change the Password for Your Own User Account in MySQL? If you want to change the password of...
How To Turn on mysql Extension on the PHP Engine in MySQL? The "mysql" API extension is provided as ...