Re: Insert Data in Table from Excel sheet

[ergi veseli]

#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 ''data' FIELDS TERMINATED BY ',' ENCLOSED BY ',' LINES TERMINATED BY '\r\n' ' at line 2
I have this problem when i use this code:
LOAD DATA LOCAL INFILE '/USER-PC\Users\user\Desktop\for_mysql\list.csv'
INTO TABLE 'data'
FIELDS TERMINATED BY ','
ENCLOSED BY ','
LINES TERMINATED BY '\r\n'
!!!