Export a single table structure and data from mysql

Export a single table structure and data from mysql mysqldump-u username-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 mysql port number. 2. If you do not enter the -- tables parameter, the MYSQL connection command is used to export all table data in the database www.2cto.com 1: mysql-h host address-u user name-p User Password 2) display database list: show databases; 3) display database list: show databases; 4) display data table list: show tables; 5) display the structure of the data table: name of the describe table; from the East blog