ORDER is a reserved word in standard SQL
Example : SELECT FirstName,LastName FROM Names ORDER BY LastName,FirstName;
If the column name in the table is ORDER, then put backquotes (`) around the
word ORDER when using it as a column name
INSERT INTO sections (`order`,edit,remove,section,type) VALUES
('blah','blah','blah','blah','blah');
-----Original Message-----
From: Pastor Steve [mailto:[EMAIL PROTECTED]
Sent: Tuesday, January 15, 2008 4:02 PM
To: MySQL List
Subject: Error
Greetings,
I am trying to enter this information into a database called cms_md, with a
table called sections.
INSERT INTO sections (order,edit,remove,section,type) VALUES
('blah','blah','blah','blah','blah');
I am getting an error whenever I use this.
--
Steve M
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
