mysql modify data table name

Modify the data table, including: modifying the table name, modifying the field name, modifying the data type of the field, etc. In MySQL, ALTER TABLE is used to modify the data table. Modify table name ALTER TABLE old table name RENAME [TO] new table name; illustrate Among them, TO is optional, you can have it or not.

First, check all tables in the database

Modify the table name

Check whether it has been modified success

The above is the detailed content of mysql modify data table name. For more information, please follow other related articles on the PHP Chinese website!