Renaming a MySQL table is very simple, but sometimes the syntax is hard to remember.
In the MySQL prompt type: use database_name
Now type: RENAME TABLE old_table_name TO new_table_name;
Renaming a MySQL table is very simple, but sometimes the syntax is hard to remember.
In the MySQL prompt type: use database_name
Now type: RENAME TABLE old_table_name TO new_table_name;
Renaming a MySQL table is very simple, but sometimes the syntax is hard to remember.
In the MySQL prompt type: use database_name
Now type: RENAME TABLE old_table_name TO new_table_name;
Renaming a MySQL table is very simple, but sometimes the syntax is hard to remember.
Rename a MySQL table
webdevmysqlIn the MySQL prompt type: use database_name
Now type: RENAME TABLE old_table_name TO new_table_name;
In the MySQL prompt type: use database_name
In the MySQL prompt type: use database_name
Select the database
Now type: RENAME TABLE old_table_name TO new_table_name;
Now type: RENAME TABLE old_table_name TO new_table_name;
Rename the table




Want to support Howchoo? When you buy a tool or material through one of our Amazon links, we earn a small commission as an Amazon Associate.






























