Linux Ask!

Linux Ask! is a Q & A web site specific for Linux related questions. Questions are collected, answered and audited by experienced Linux users.

Mar 022009

How to rename table in MySQL


Login into MySQL shell, and enter the following SQL

mysql> USE my_db;
mysql> RENAME TABLE old_table TO new_table;
Query OK, 0 rows affected (0.00 sec)

That's all what you need.

  One Response to “How to rename table in MySQL”

  1. Thanks a is working in mysql 5.0...

 Leave a Reply



You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>