How MySQL exports CSV format data files

1.MySQL export Local database data to local file

SQL code

The code is as follows	Copy Code
Load data infile '/tmp/test.csv ' into table Test_info Fields terminated by ', ' optionally enclosed by ' "' escaped by '" ' Lines terminated by ' RN '; Load data infile '/tmp/test.csv ' into table Test_info Fields terminated by ', ' optionally enclosed by ', ' escaped by '

"'
Lines terminated by ' RN '; The key part of it is the format parameter.

2.MySQL Export remote database data to local file

The code is as follows	Copy Code
Mysql-a service_db-h your_host-utest-ptest-ss-e "select * from T_apps limit 300;" | Sed ' s/t/', '/g;s/^/'/;s/$/'/;s/n//g ' > Apps.csv

(SED part is abbreviated, especially when dealing with data containing Chinese characters)

3. MYSQLDUMP export CSV Format data file

The code is as follows	Copy Code
# Use the following method Mysqldump-uroot-ppassword-t-t/root testdb--fields-enclosed-by= "--fields-terminated-by=, Cases Mysqldump-h your_host-utest-ptest-w "id<300" service_db T_apps > Tt.sql

The following export formats are:

code is as follows	copy code
"1", " m11401 "," 2013-06-22 23:00:01 " " 2 "," m11402 "," 2013-06-22 23:00:02 " " 3 "," m11403 "," 2013-06-22 23:00:03 "