From: Rolando Edwards (redwardslogicworks.net)
Date: Tue Jan 15 2008 - 15:17:26 CST

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

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:smarquezccfortsmith.com]
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

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]