温柔的过堂风

原创 Excel文件导入Mysql

将excel另存为csv文件 新建一张表，字段数量和csv字段数量一致 写sql LOAD DATA LOCAL INFILE 'C:\\Users\\chenph\\Desktop\\1.csv' INTO TABLE test.b CHARACTER SET gbk FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' ESCAPED