mysql query error for my query

Question

I'm getting this 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 'VALUES (1039,200,'2',NULL,NULL,NULL,'cash',NULL,1)' at line 1

for this query:

INSERT INTO anu_donations (projectid,donation_amount,donated_by,donated_by_uid,donation_details, comments,payment_medium,donor_comments,created_by)

VALUES (1039,100,'1',NULL,NULL,NULL,'cash',NULL,1), VALUES (1039,200,'2',NULL,NULL,NULL,'cash',NULL,1);

enter image description here

Community · Accepted Answer · 2020-06-20 09:12:55Z

1

You only need VALUES once

INSERT INTO anu_donations    
(projectid,donation_amount,donated_by,donated_by_uid,donation_details, 
comments,payment_medium,donor_comments,created_by)

VALUES 
   (1039,100,'1',NULL,NULL,NULL,'cash',NULL,1), 
   (1039,200,'2',NULL,NULL,NULL,'cash',NULL,1);

See INSERT in the MySQL docs:

INSERT statements that use VALUES syntax can insert multiple rows. To do this, include multiple lists of column values, each enclosed within parentheses and separated by commas. Example:
INSERT INTO tbl_name (a,b,c) VALUES(1,2,3),(4,5,6),(7,8,9);

edited Jun 20, 2020 at 9:12

CommunityBot

11 silver badge

answered Dec 29, 2011 at 10:14

gbn

434k84 gold badges602 silver badges690 bronze badges

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

Comments

Buhake Sindi · Accepted Answer · 2011-12-29 10:19:15Z

0

The SQL Statement for INSERT Syntax is as follows:

INSERT [LOW_PRIORITY | DELAYED | HIGH_PRIORITY] [IGNORE]
    [INTO] tbl_name [(col_name,...)]
    {VALUES | VALUE} ({expr | DEFAULT},...),(...),...
    [ ON DUPLICATE KEY UPDATE
      col_name=expr
        [, col_name=expr] ... ]

Thus, you can see that VALUES is used once. Thus, you need to change your SQL as follows:

INSERT INTO anu_donations (projectid,donation_amount,donated_by,donated_by_uid,donation_details, comments,payment_medium,donor_comments,created_by)

VALUES (1039,100,'1',NULL,NULL,NULL,'cash',NULL,1), (1039,200,'2',NULL,NULL,NULL,'cash',NULL,1);

answered Dec 29, 2011 at 10:19

Buhake Sindi

89.5k30 gold badges176 silver badges234 bronze badges

Collectives™ on Stack Overflow

mysql query error for my query

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related