MySQL 1064: You have an error in your SQL syntax

Question

I need some help in this SQL Code. I am new to SQL and using the Sams Teach Yourself SQL.

   INSERT INTO `eli`.`checks`
(`check`,
`payee`,
`amount`,
`remarks`)
VALUES
(500,'John Dree',450.00,'Bills');
INSERT INTO `eli`.`checks`
(`check`,
`payee`,
`amount`,
`remarks`)
VALUES
(575,'Ma Belle',150.00,'Gas Bills');
INSERT INTO `eli`.`checks`
(`check`,
`payee`,
`amount`,
`remarks`)
VALUES
(600,'Jon Cash',350.00,'Shopping');

I am getting 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 'payee, amount, reINSERT INTO eli`.checks' at line 1

enter image description here Thank you :)

This means that there is already a record in your checks table with the value of 19200 for your check field and you can't insert duplicates. — sgeddes
– sgeddes, Commented Sep 17, 2014 at 19:11
Your check field is your primary key. It cannot already exist. So if 4 exists in that table, you'll get the same error. — sgeddes
– sgeddes, Commented Sep 17, 2014 at 19:14
Now -_- I am getting 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 'payee, amount, reINSERT INTO eli.checks`' at line 1 — Pixel Code
– Pixel Code, Commented Sep 17, 2014 at 19:16

John Guan · Accepted Answer · 2014-09-17 19:50:56Z

2

Try this?

INSERT INTO `eli`.`checks` (`check`, `payee`, `amount`, `remarks`) VALUES
(500, 'John Dree', 450.00, 'Bills'),
(575, 'Ma Belle', 150.00, 'Gas Bills'),
(600, 'Jon Cash', 350.00, 'Shopping');

answered Sep 17, 2014 at 19:50

John Guan

7443 gold badges12 silver badges26 bronze badges

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

Collectives™ on Stack Overflow

MySQL 1064: You have an error in your SQL syntax

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related