Rename A Mysql Table

By admin ·
1

Select the database

In the MySQL prompt type: use database_name

2

Rename the table

Now type: RENAME TABLE old_table_name TO new_table_name;

3

Select the database

In the MySQL prompt type: use database_name

4

Rename the table

Now type: RENAME TABLE old_table_name TO new_table_name;

5

Select the database

In the MySQL prompt type: use database_name

6

Rename the table

Now type: RENAME TABLE old_table_name TO new_table_name;

7

Select the database

In the MySQL prompt type: use database_name

8

Rename the table

Now type: RENAME TABLE old_table_name TO new_table_name;

9

Select the database

In the MySQL prompt type: use database_name

10

Select the database

In the MySQL prompt type: use database_name

11

Select the database

12

Rename the table

Now type: RENAME TABLE old_table_name TO new_table_name;

13

Rename the table

Now type: RENAME TABLE old_table_name TO new_table_name;

14

Rename the table