MySQL Export data

A, select * from Black_list1 into outfile "D:/1234.txt";

Mysql> SELECT * from Black_list1 to outfile "D:/1234.txt"; Query OK, 790913 rows affected (4.49 sec)

Results:

Mysql> SELECT * from Black_list1 to outfile "D:/12345.txt" Fields terminated by "," lines terminated by "\ n"; Query OK, 790913 rows Affected (4.41 sec)

Results:

Two: mysqldump

1. Export the database

E:\xampp\mysql\bin>mysqldump-u Root-p black > dump.sql//in mysql/bin/enter Password: ******

E:\xampp\mysql\bin>mysqldump-u root-p-D black > black.sql//only table structure Enter password: ******

　　

2. Export a table

E:\xampp\mysql\bin>mysqldump-u root-p Black black_list1 > Black_list3.sqlenter Password: ******

E:\xampp\mysql\bin>mysqldump-u root-p-D black > black.sql//only table structure Enter password: ******

　　

E:\xampp\mysql\bin>mysqldump-u root-p-T Black black_list3 > black4.sql//only data Enter password: ******

　　

adjourned

MySQL Export data