How MySQL only exports the table structure and data for the specified table (GO)

MySQL How to export only the table structure and data for the specified table (go) 2011-01-04 15:03:33

Category: MySQL

How MySQL only exports table structure and data for a specified table
The table structure for exporting a more library is as follows:
Mysqldump-uroot-p-D databasename > Createtab.sql,

What if you only want to export the table structure and data for table Test1,test2,test3?
How do I export it?

Mysqldump-uroot-p-D databasename test1 test2 test3 > Createtab.sql

--The above is the export of the specified table structure, the following can export the specified table structure and data
Mysqldump-uroot-p--tables databasename > Createtab.sql

Mysqldump-uroot-p-D databasename test1 test2 test3 > Createtab.sql,
The table structure for exporting a more library is as follows:
Mysqldump-uroot-p-D databasename > Createtab.sql,

What if you only want to export the table structure and data for table Test1,test2,test3?
How do I export it?

Mysqldump-uroot-p-D databasename test1 test2 test3 > Createtab.sql

--The above is the export of the specified table structure, the following can export the specified table structure and data
Mysqldump-uroot-p--tables databasename > Createtab.sql

Mysqldump-uroot-p-D databasename test1 test2 test3 > Createtab.sql,

[@[email protected]]

How MySQL only exports the table structure and data for the specified table (GO)