error creating table

[drtanz]

i need help to know what's wrong with this sql statement, its giving me an error in phpmyadmin:

 

create table tbl_questions (id int unsigned not null auto_increment primary key, label varchar(255) not null, type varchar(255) not null, required varchar(3) not null, order int unsigned not null, active varchar(3) not null, survey_id int unsigned not null);

 

error:

MySQL said: 

 

#1064 - 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 int unsigned not null, active varchar(3) not null, survey_id int unsigned ' at line 1

 

 

[fenway]

order is a reseved keyword... pick another name for the field, like sortorder.

[hitman6003]

you could enclose the "order" in backticks ( ` ... not a single quote ), but as fenway suggested, choosing column names that are not reserved words is by far the best choice.

 

http://www.mysql.com/identifiers