mysql导入导出到csv

-- 从外部导入csv文件
LOAD DATA LOCAL INFILE 'C:/tigerworkspace/ftp/name.csv'
INTO TABLE table
FIELDS TERMINATED BY ','
LINES TERMINATED BY '\r\n'
(column1column2,column3);


-- 从mysql导出成csv文件
SELECT column1column2,column3 INTO OUTFILE 'C:/tigerworkspace/ftp/name.csv'
FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"'

LINES TERMINATED BY '\n'

FROM `table`;

-- 远程导出一个库或表

mysql -A database -hIP -uusername -Pprort -ppassword -ss -e "SELECT * from table;" > c:\tigerworkspace\test.sql
mysqldump -hIP -uusername -P3306 -ppassword database table,table1  > c:\tigerworkspace\a.sql