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
解决方案 »
- 求大神帮助,3~4张表之间数据复制问题,
- 请问大家一个问题啊,我想做软件,即从网上下载下的文章可以放到服务器中,所以数据库的检索量是相当大的,现在我想问的是应该使用什么样的数据库?(这个可能存放上百万的
- 急求解决mysql无法远程连接问题ERROR 2003 (HY000): Can't connect to MySQL server on '202.99.67
- 搜索查询问题
- 求教一个错误
- 在线等:sql错误
- Mysql 查询速度慢
- 为什么我在MySQ中关键字不能排序?(在线等!)
- mysql 存储过程 如何移动指针,直接到最后一条记录
- 难问题.不通过程序,而直接sql语句删除掉数据库重复记录的数据.比如ID相同的就删除掉.
- 如何计算排序后的表中相邻的两条记录的某时间字段的值之差
- mysql 密码问题 xp系统下的不是linux哦
LOAD DATA INFILE 'c:/db.txt'
INTO TABLE tableName
FIELDS TERMINATED BY '|'
LINES TERMINATED BY '\n'
(filed1,filed2,filed3)