drtanz Posted May 1, 2008 Share Posted May 1, 2008 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 Quote Link to comment Share on other sites More sharing options...
fenway Posted May 1, 2008 Share Posted May 1, 2008 order is a reseved keyword... pick another name for the field, like sortorder. Quote Link to comment Share on other sites More sharing options...
hitman6003 Posted May 3, 2008 Share Posted May 3, 2008 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 Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.