MySql数据导出到cvs文件命令:
[quote]SELECT id,title,type INTO OUTFILE 'e:\\output_01.csv'
FIELDS TERMINATED BY ' ' OPTIONALLY ENCLOSED BY '"'
LINES TERMINATED BY '\n'
FROM music;[/quote]
cvs文件导入MySql数据库命令:
set names utf8;
LOAD DATA LOCAL INFILE 'C:\\resource.csv'
INTO TABLE resource
FIELDS TERMINATED BY ' '
LINES TERMINATED BY '\r\n'
(title,singer);
FIELDS TERMINATED BY ---- 字段终止字符
OPTIONALLY ENCLOSED BY ---- 封套符
LINES TERMINATED BY ---- 行终止符
[quote]SELECT id,title,type INTO OUTFILE 'e:\\output_01.csv'
FIELDS TERMINATED BY ' ' OPTIONALLY ENCLOSED BY '"'
LINES TERMINATED BY '\n'
FROM music;[/quote]
cvs文件导入MySql数据库命令:
set names utf8;
LOAD DATA LOCAL INFILE 'C:\\resource.csv'
INTO TABLE resource
FIELDS TERMINATED BY ' '
LINES TERMINATED BY '\r\n'
(title,singer);
FIELDS TERMINATED BY ---- 字段终止字符
OPTIONALLY ENCLOSED BY ---- 封套符
LINES TERMINATED BY ---- 行终止符