MySQL Modify data table name

When using MySQL, you often encounter table names that do not conform to specifications or standards, but the tables already have a lot of data, how to keep the data, just change the table name?

You can import the original data into a new table by building a table of the same table structure, but that's a lot of trouble.

Can you simply use an SQL statement to get it done? Of course, mysql5.0 we can use this SQL statement.

alter   table  table_name rename  to  new_table_name

For example  < Span style= "color: #990002;" >alter    TABLE  admin_user rename  to  a_user