wemustdesign Posted April 3, 2009 Share Posted April 3, 2009 I am using the latest version of MySQL. I am installing a script but am getting an error when trying to create a table. Here is the SQL that creates the table: CREATE TABLE "iso_countries" ( "iso" char(2) NOT NULL default '', "name" varchar(80) NOT NULL default '', "printable_name" varchar(80) NOT NULL default '', "iso3" char(3) default NULL, "numcode" smallint(6) default NULL, PRIMARY KEY ("iso") ); This is the error I am getting #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 '"iso_countries" ( "iso" char(2) NOT NULL default '', "name" varchar(80) NO' at line 1 I have no idea what the problem is... Quote Link to comment https://forums.phpfreaks.com/topic/152411-create-table-error/ Share on other sites More sharing options...
Maq Posted April 3, 2009 Share Posted April 3, 2009 Remove the double quotes, you can use backtics if you'd like for the column names. Besides that, it looks fine to me. Quote Link to comment https://forums.phpfreaks.com/topic/152411-create-table-error/#findComment-800428 Share on other sites More sharing options...
wemustdesign Posted April 3, 2009 Author Share Posted April 3, 2009 Tried it but is still giving me an error. Is puzzling me #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 ''iso_countries' ( 'iso' char(2) NOT NULL default '', 'name' varchar(80) NO' at line 1 Quote Link to comment https://forums.phpfreaks.com/topic/152411-create-table-error/#findComment-800439 Share on other sites More sharing options...
fenway Posted April 3, 2009 Share Posted April 3, 2009 That's single quotes... drop the quotes entirely. And don't use a CHAR() for your PK! Quote Link to comment https://forums.phpfreaks.com/topic/152411-create-table-error/#findComment-800472 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.