导入csv到mysql的语句如下:
LOAD DATA INFILE 'C:\\Users\\Administrator\\Desktop\\ky\\grxx.csv'
INTO TABLE `grxx` #要插入的表
CHARACTER SET utf8 #设置表编码
FIELDS TERMINATED BY ',' #字段以,分隔
OPTIONALLY ENCLOSED BY '"'
ESCAPED BY '"' #字段以"包围
LINES TERMINATED BY '\r\n' #换行符表示一行结束
IGNORE 1 LINES #忽略第一行
(`index`, `ybh`, `idnum`, `name`, `sex`, `birthday`, `companycode`, `companyname`, `phone`, `dept`); #csv文件中数据按此顺序插入表中
从mysql导出csv语句
select * from `table`
load data infile 'C:\\Users\\UserName\\Desktop\\test.csv'
fields terminated by ',' optionally enclosed by '"' escaped by '"'
lines terminated by '\n';