LOAD DATA INFILE 'c:/db.txt'
//表名和字段名(我要导入的字段)
INTO TABLE tableName(filed1,filed2,filed3)
//每个字段分隔符
FIELDS TERMINATED BY '|'
//每个行分隔
LINES TERMINATED BY '\n'错误提示如下1064
you have an error in your sql syntax;
check the manual that corresponds to your mysql
server version for the right syntax to use near
'fields terminated by '1' lines terminated by "\n"
at line 3
//表名和字段名(我要导入的字段)
INTO TABLE tableName(filed1,filed2,filed3)
//每个字段分隔符
FIELDS TERMINATED BY '|'
//每个行分隔
LINES TERMINATED BY '\n'错误提示如下1064
you have an error in your sql syntax;
check the manual that corresponds to your mysql
server version for the right syntax to use near
'fields terminated by '1' lines terminated by "\n"
at line 3
LOAD DATA INFILE 'c:/db.txt'
INTO TABLE tableName
FIELDS TERMINATED BY '|'
LINES TERMINATED BY '\n'
(filed1,filed2,filed3)