Rename an Existing Table in MySQL

Q

How To Rename an Existing Table in MySQL?

✍: FYIcenter.com

A

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)

 

CREATE, ALTER and DROP Statements in MySQL

⇒⇒MySQL Database Tutorials

2016-10-16, 185👍, 0💬