file io - MySQL LOAD DATA INFILE error -


i try load data column table following sql-statement:

load data infile 'filelist.txt' table filelist (filepath) lines terminated '#'; 

the structure of data in each line this:

file:://///...path...txt# 

and following error message:

you have error in sql syntax near 'lines terminated '#' 

i don't know wrong. ideas?

try removing 'lines terminated '#' sql-statement. run "load data infile 'filelist.txt' table filelist (filepath)" ... comment


Comments

Popular posts from this blog

How do you change vbulletin's home page to the forums instead of the default (CMS or Activity Stream)? -

java - stack overflow exception on xml transformation -