Export a single table structure and data from MySQL

Mysqldump-u user name-P password-P port number -- database name -- tables Table Name> C:/export file name. SQL

1. The parameter-P can be omitted unless your port number is not the default port number of MySQL.

2. If you do not write the -- tables parameter, it means to export all the table data in the DB.

 

1) MySQL connection command:
Mysql-H host address-u user name-P User Password

2) display the Database List:
Show databases;

3) display the Database List:
Show databases;

4) display the data table list:
Show tables;

5) display the data table structure:
Describe table name;