MySQL Error #1064 on this INSERT?

Question

Not sure what's wrong, just running this in PHP MyAdmin right now. Does anything pop out to you? Thanks.

INSERT INTO order (CustomerID, BillAddr, ShipAddr, Date, Total)   
VALUES ('test', 'test', 'test', '2012-07-02', 22)

Error:

MySQL said: #1064

Structure of order table:

FIELD                TYPE  
OrderID         int(11) auto increment  
CustomerID      varchar(50)  
BillAddr        varchar(200)  
ShipAddr        varchar(200)  
Date            date  
Total           double

(I leave the OrderID out of the INSERT as it is an auto increment)

EDIT
Same error with this syntax:

SQL query:

INSERT INTO 'order'( CustomerID, BillAddr, ShipAddr, 'Date', Total )
VALUES (
'test', 'test', 'test', '2012-07-02', 22
)
MySQL said: Documentation
#1064 -

score 12 · Accepted Answer · answered Jul 02 '12 at 19:42

12

The word Date is a keyword. Try it like this:

INSERT INTO `order` (CustomerID, BillAddr, ShipAddr, `Date`, Total)   
VALUES ('test', 'test', 'test', '2012-07-02', 22)

ETA: And order is also a keyword :)

answered Jul 02 '12 at 19:42

Eric Petroelje

59,820
9
127
177

single quotes around the key words.... still getting 1064? please see the edit to the question. – Greg McNulty Jul 02 '12 at 19:51
1

@greg, not single-quotes but back-ticks. Single-quotes are for strings. – Ben Jul 02 '12 at 19:52
1

@greg - You can also use double quotes in ANSI mode instead of backticks. – Eric Petroelje Jul 02 '12 at 19:54
@Eric Petroelje: the back ticks did it, I have never used those in my life, not sure if i should admit that. OK thanks, I will rememberthe double quotes too! – Greg McNulty Jul 02 '12 at 19:55
Thanks for the answer, I got bitten on the `group` keyword. – dstudeba Nov 20 '17 at 23:12

MySQL Error #1064 on this INSERT?

1 Answers1