Create Table Error

[wemustdesign]

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...

[Maq]

Remove the double quotes, you can use backtics if you'd like for the column names.  Besides that, it looks fine to me.

[wemustdesign]

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 

[fenway]

That's single quotes... drop the quotes entirely.

 

And don't use a CHAR() for your PK!