mysql csv文件简单导入导出

-- 导出csv文件
SELECT 
	t_user.`username`,t_user.`password`,t_user.`role_id` 
FROM 
	t_user 
INTO OUTFILE 'E://360Downloads//test.csv'
	-- 字段间逗号分隔
	FIELDS TERMINATED BY ','
	-- 认为双引号中的是一个独立的字段。有特殊字符（逗号、顿号等）的字段，会自动用双引号引起来
	OPTIONALLY ENCLOSED BY '"'
	-- 每行数据在csv文件以什么结束
	LINES TERMINATED BY '\n';
-- 导入scv文件
LOAD DATA INFILE 'E://360Downloads//test.csv' 
	INTO TABLE t_test2 
	FIELDS TERMINATED BY ',' 
	OPTIONALLY ENCLOSED BY '"' 
	LINES TERMINATED BY '\n'(aa,bb,cc);;