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 www.GlobalGuideLine.com | NULL |+----+-------------+-------------------------+--------+1 row in set (0.00 sec)
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 www.GlobalGuideLine.com | NULL |+----+-------------+-------------------------+--------+1 row in set (0.00 sec)
Comments Received:
Please give your suggestions and feedback: