What is the statement to modify the table name in MySQL?

The key statement to modify the MySQL table name statement "RENAME TO"

The syntax is as follows:

ALTER TABLE 表名1 RENAME TO 表名2;

First open mysql Tool (take Navacate for mysql as an example)

Download address:https://www.php.cn/xiazai/gongju/757

Then select the database to be tested, click [Query]-》[New Query]

Then enter the sql statement to modify the table name

Finally click " Run" to see if the table name changes.

Related references:php MySQL Tutorial

The above is the detailed content of What is the statement to modify the table name in MySQL?. For more information, please follow other related articles on the PHP Chinese website!