加载数据文件时出现MySQL错误 [英] MySQL error loading data file

问题描述

我试图执行此查询不幸的是，我得到一个错误，任何人都可以告诉为什么这个错误出现，我错了

我的查询：

  LOAD DATA INFILE'/wamp/www/var/Book1.csv'INTO TABLE contact 
 '''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''' dummy，@dummy，@dummy，@dummy，@dummy，column4，@dummy，@dummy，@dummy，@dummy，@dummy，@dummy，@dummy，@dummy，@ @ dummy，@dummy，@dummy，@dummy，@dummy，@dummy，@dummy，@dummy，@dummy，@dummy，@dummy，@dummy，$ d 
）; 
  pre> 
 
 
 错误： 
  1064  - 您的SQL语法中有错误;检查与您的MySQL服务器版本对应的手册，以获取在'FIELDS TERMINATED BY'，'
 ENCLOSED BY'''
附近使用的正确语法BY'\\\
'
在第4行处的IGNORE 1 LINES'
  
 
 
解决方案
您必须更改字段... 和列名称的顺序：
  LOAD DATA INFILE'/wamp/www/var/Book1.csv'INTO TABLE contact 
终止'，''''''''''' IGNORE 1 LINES 
（
 @dummy，@dummy，name，@dummy，nationality，mobile1，@dummy，@dummy，@dummy，@dummy，@dummy，@dummy，twon，@dummy， @dummy，@dummy，@dummy，@dummy，@dummy，@dummy，@dummy，@dummy，@dummy，@dummy，@dummy，@dummy，@dummy，@dummy，@dummy，@dummy，@dummy ，@dummy，@dummy，@dummy，@dummy 
）; 
  
 
i am trying to execute this query unfortunately i am getting an error ,can anyone tell why this error appear,where i went wrong

my query:
    LOAD DATA INFILE '/wamp/www/var/Book1.csv' INTO TABLE contact
FIELDS TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY '\n' IGNORE 1 LINES
(
@dummy , @dummy , column1, @dummy , column3, column2, @dummy , @dummy , @dummy , @dummy , @dummy , @dummy , column4, @dummy , @dummy , @dummy , @dummy , @dummy , @dummy , @dummy , @dummy , @dummy , @dummy , @dummy , @dummy , @dummy , @dummy , @dummy , @dummy , @dummy , @dummy , @dummy , @dummy , @dummy , @dummy
)  ;
Error:
#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 ','
ENCLOSED BY '"'
LINES TERMINATED BY '\n'
IGNORE 1 LINES' at line 4 

解决方案
You have to change the order of fields... and the column names:
LOAD DATA INFILE '/wamp/www/var/Book1.csv' INTO TABLE contact
FIELDS TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY '\n' IGNORE 1 LINES
(
@dummy , @dummy , name, @dummy , nationality, mobile1, @dummy , @dummy , @dummy , @dummy , @dummy , @dummy , twon, @dummy , @dummy , @dummy , @dummy , @dummy , @dummy , @dummy , @dummy , @dummy , @dummy , @dummy , @dummy , @dummy , @dummy , @dummy , @dummy , @dummy , @dummy , @dummy , @dummy , @dummy , @dummy
)  ;


                        
这篇关于加载数据文件时出现MySQL错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！