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, 1315🔥, 0💬
Popular Posts:
What Are Date and Time Functions in MySQL? MySQL offers a number of functions for date and time valu...
How To Drop a Stored Procedure in Oracle? If there is an existing stored procedure and you don't wan...
How to download and install the scaled-down database AdventureWorksLT in SQL Server? If you want to ...
How AdventureWorksLT tables are related in SQL Server? There are 12 user tables defined in Adventure...
Why I Can Not Enter 0.001 Second in DATETIME values in SQL Server Transact-SQL? If you enter millise...