Insert Into Table Syntax
Posted by:
Jay Marino
Date: August 14, 2004 08:29PM
Hello Folks,
For some reason this insert statement does not work:
Does not work:
INSERT INTO order
(user_id,order_tax1,order_tax2,creation_date,order_contact)
VALUES (27,7,7.5,'2004-08-14 17:51:56','helloworld@helloworld.net')
However, when I enclose the table name with the ` character then the
insert takes place just fine.
Works:
INSERT INTO `order`
(user_id,order_tax1,order_tax2,creation_date,order_contact)
VALUES (27,7,7.5,'2004-08-14 17:51:56','helloworld@helloworld.net')
My concern is that I might have changed something, because in all my other statements I have never enclosed the table name with the ` character
Any idea?