The method of setting table name by mysql

Editor to share with you how to set the table name of mysql, I believe that most people do not know much about it, so share this article for your reference, I hope you can learn a lot after reading this article, let's go to know it!

Mysql sets the name of the table: through the alter table statement, use the SQL code "ALTER TABLE RENAME [TO];" to set and modify the name of the data table; TO is an optional parameter, using or not does not affect the result.

Requirements description:

Today, in the historical data migration of mysql table, we need to back up a table, change the name of the table, and record the operation process here.

Operation procedure:

Mysql > create table ts01 like ti_o_sms; # create the table structure. In this way, not only the structure of the table, but also the index will be created at the same time. Query OK, 0 rows affected (0.02 sec) mysql > alter table ts01 rename to ts01_new; # modify the syntax of the table name: alter table rename to/as new_tablename;Query OK, 0 rows affected (0 sec) mysql > show tables +-+ | Tables_in_mytest | +-+ | sms_send_blacklist | | td_b_sendobject | | ti_o_sms | | ts01_new | +-+ 4 rows in set (0) .00 sec) or mysql > alter table ts01_new rename AS ts02 Query OK, 0 rows affected mysql > show tables;+-+ | Tables_in_mytest | +-+ | sms_send_blacklist | | td_b_sendobject | | ti_o_sms | | ts02 | +-+ 4 rows in set (0.00 sec)

Note: the table name has been successfully modified.

The official document modifies the syntax of the table name:

Mysql help RENAME above is all the contents of mysql's method of setting table names. Thank you for reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more knowledge, welcome to follow the industry information channel!