SQL statement for modifying table names in MySQL

When using MySQL, we often encounter table names that do not comply with the specifications or standards, but there is already a large amount of data in the table. How can we keep the data and only change the table name? You can create an identical

When using MySQL, we often encounter table names that do not comply with the specifications or standards, but there is already a large amount of data in the table. How can we keep the data and only change the table name? You can create an identical

When using MySQL, we often encounter table names that do not comply with the specifications or standards, but there is already a large amount of data in the table. How can we keep the data and only change the table name?

You can create a table with the same table structure and import the original data to the new table, but this is very troublesome.

Can I simply use an SQL statement? Of course, you can use this SQL statement in MySQL 5.0.

Alter table table_name rename to new_table_name

For example, alter table admin_user rename to a_user