How to rename a table?

wxdqz

New Member
Hi, i have tried this command,
"rename table old_db to new_db" but cannot work. The mysql server return error message.
"ERROR 1064: You have an error in your SQL syntax near 'rename table master_db2 to master_db' at line 1"

Anyone know why and how to solve it?

Thankz
 
Back
Top