Bulk Data InsertQuery error in Mysql

Question

I have a .csv file that i need to insert into database table using.Here is the query that i am using ..

LOAD DATA INFILE 'C:\Users\vikas\Desktop\UserDetails.txt' INTO employee_users  FIELDS TERMINATED BY ',' LINES TERMINATED BY ''(@UserName,@EmpID,@DepName,@MailId,@MonthlyQuota)

But i am getting error.

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 'employee_users  FIELDS TERMINATED BY ',' LINES TERMINATED BY ''(@UserName,@EmpI' at line 1

Please help me to resolve this.

Vamsi Krishna · Accepted Answer · 2014-03-25 07:59:41Z

1

Can you try adding table before employee_users

LOAD DATA INFILE 'C:\Users\vikas\Desktop\UserDetails.txt' INTO TABLE employee_users FIELDS TERMINATED BY ',' LINES TERMINATED BY ''(@UserName,@EmpID,@DepName,@MailId,@MonthlyQuota)

Syntax Reference: LOAD DATA INFILE SYNTAX

answered Mar 25, 2014 at 7:59

Vamsi Krishna

3,7924 gold badges22 silver badges45 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Bulk Data InsertQuery error in Mysql

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related