mysql导出数据

mysql> select * from black_list1 into outfile "D:/1234.txt";
Query OK, 790913 rows affected (4.49 sec)

mysql> select * from black_list1 into outfile "D:/12345.txt" fields terminated b
y "," lines terminated by "\n";
Query OK, 790913 rows affected (4.41 sec)

E:\xampp\mysql\bin>mysqldump -u root -p black > dump.sql//在mysql/bin/
Enter password: ******

E:\xampp\mysql\bin>mysqldump -u root -p -d black > black.sql//只有表结构
Enter password: ******

E:\xampp\mysql\bin>mysqldump -u root -p black black_list1 > black_list3.sql
Enter password: ******

E:\xampp\mysql\bin>mysqldump -u root -p -d black > black.sql//只有表结构
Enter password: ******

E:\xampp\mysql\bin>mysqldump -u root -p -t black black_list3 > black4.sql//只有数据
Enter password: ******