mysql使用SQLyog导入csv数据不成功的解决方法
LOAD DATA LOCAL INFILE
'C:\\Users\\Administrator\\Desktop\\123.csv'
INTO TABLE lz_xiuyu.adminp
CHARACTER SET gbk
FIELDS TERMINATED BY ','
OPTIONALLY ENCLOSED BY '"'
ESCAPED BY '"'
LINES TERMINATED BY '\r\n'
( id,`province`, `city`, `location`, `store_type`, `username`, `platname` )
页:
[1]