Mysql Command for exporting table data

Mysql Command for exporting table data

1. Export the entire data table

Run the command line to enter the installation directory/Bin/mysqldump-u username-p password-hIP address or localhost database name Table Name> C: \ table1.txt and press Enter.

2. Export The data in the table according to the conditions.

Enter the installation directory/Bin/mysqldump-u username-p password-hIP address or localhost database name table name -- where = "condition"> C: \ table2.txt and press Enter.

For example:

Run the command line to enter the installation directory/Bin/mysqldump-u userName-p password-hIP address or localhost database name table name -- where = "id> 100 and userName like 'Lee % 'order id limit 100 "> C: \ demo2.txt press ENTER