Mysql export database table structure commands

In the past, what I introduced most was to export the data in the database, so that the data and structure in the table can be exported directly. Today, only the data structure needs to be exported without the table, let's take a look at the implementation method.

Export database command:

The command line is used as follows: mysqldump-u username-p password-d database name table name Script Name;

Mysqldump-h host address-u user name-p Password Database Name> SQL .txt

Mysqldump-h host address-u user name-p Password Database Name-d> SQL .txt only exports sechema, not data

Database Import command:

Mysql-h host address-P port-u username-p password <SQL .txt

The method is simple. to export the table structure, you only need to include the-d parameter.