Of the 30-something queries I run against the db, the only one that has given me any problems is the following:

(the values of CustomerID and CartID are obviously somewhat dynamic)


Yet when I run the query, I get a syntal error

and that syntax error would be .... ?

what are the datatypes of those two columns?

are there any other columns in that table?
are they NULL, or have default values declared?

My bad. Here's some more info:

The error I'm getting is: 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 'order (CustomerID, CartID) VALUES ('000000000000000015', '

Datatypes: CustomerID VARCHAR(18) NO; CartID VARCHAR(32)

Neither one of the columns are NULL, nor do they have a default value assigned to them.

The only other column in the table is OrderID, which comes before CustomerID and CartID, in that order.

perhaps it is the table name, order, which is a reserved word

try putting the table in backticks... insert into `order`

your best bet would be to rename it

Well, r937 was exactly right. After changing the table name from "order" to "orders", the query worked perfectly!

Let this be a lesson to everyone: Don't name any of your tables using a reserved word.

Thanks r937.