load data infile 'D:/1.csv' into table tablename fields terminated by ',' lines terminated by '/n';
将csv格式的文件(行分隔符为换行符,列分隔符为逗号)Load进数据库
load data infile 'D:/1.csv' into table tablename fields terminated by ',' lines terminated by '/n';
将csv格式的文件(行分隔符为换行符,列分隔符为逗号)Load进数据库