How To Rename An Existing Table In MySQL

How To Rename An Existing Table In MySQL


  • 24 Feb, 2012

    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:

2009-2016 downloadmela.com. All rights reserved.