1、每条数据独占一行
LOAD DATA LOCAL INFILE 'd:/s.txt' INTO TABLE TABLE_NAME(FIELD);
2、数据用逗号分隔
LOAD DATA LOCAL INFILE 'd:/s.txt' INTO TABLE TABLE_NAME LINES TERMINATED BY ',' ( FIELD);
1、每条数据独占一行
LOAD DATA LOCAL INFILE 'd:/s.txt' INTO TABLE TABLE_NAME(FIELD);
2、数据用逗号分隔
LOAD DATA LOCAL INFILE 'd:/s.txt' INTO TABLE TABLE_NAME LINES TERMINATED BY ',' ( FIELD);