[SOLVED] syntax error

[rondog]

I received a bunch of sql files that I should just be able to copy and paste into a query window, but im getting this error:

 

/* SQL Error: 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 '"ssp_images" (  "id" int(11) NOT NULL auto_increment */

 

Here is my sql file:

CREATE TABLE "ssp_images" (
  "id" int(11) NOT NULL auto_increment,
  "aid" int(11) default NULL,
  "title" varchar(255) default NULL,
  "src" varchar(255) default NULL,
  "caption" text,
  "link" text,
  "active" tinyint(1) NOT NULL default '1',
  "seq" int(4) NOT NULL default '999',
  "pause" int(4) NOT NULL default '0',
  "target" tinyint(1) NOT NULL default '0',
  "updated_on" timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  "created_on" timestamp NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  ("id")
) AUTO_INCREMENT=5;

 

I cant spot the error..anyone know?

[DarkWater]

Take the quotes off the table and column names.

[rondog]

Take the quotes off the table and column names.

 

sweet thanks..worked

[DarkWater]

Any time.