How to export table structure in mysql database

This article is to share with you about how to derive the table structure in the mysql database, the editor thinks it is very practical, so I share it with you to learn. I hope you can get something after reading this article.

Export of mysql structure

The specific usage on the command line is as follows:

Dump-u uses username-p password-d database name table name > script name

Export the entire database structure and data

Mysqldump-h localhost-uroot-p123456 database > dump.sql

Export a single data table structure and data

Mysqldump-h localhost-uroot-p123456 database table > dump.sql

Www.2cto.com

Export the entire database structure (without data)

/ usr/local/mysql/bin/mysqldump-uroot-d entrym > dump.sql

Export a single data table structure (without data)

Mysqldump-h localhost-uroot-p123456-d database table > dump.sql

The above is how to derive the table structure in the mysql database. The editor believes that there are some knowledge points that we may see or use in our daily work. I hope you can learn more from this article. For more details, please follow the industry information channel.