Shulou(Shulou.com)06/01 Report--

Modify the key statement "RENAME TO" of the MySQL table name statement

The syntax is as follows:

ALTER TABLE Table name 1 RENAME TO Table name 2

First open the mysql tool (take Navacate for mysql as an example)

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

Then select the database to test, and click [query]-"[New query]

Then enter a sql statement that modifies the table name

Finally, click "run" to see if the table name has changed.

These are the details of what MySQL modifies the table name statement, please pay attention to other related articles!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.