whats rowng with this sql

can any one help me with this sql

Erreur

requête SQL:

-- 
-- Table structure for table `cached`
-- 
CREATE TABLE `cached` (
`id` int( 11 ) NOT NULL AUTO_INCREMENT ,
`listingid` int( 11 ) NOT NULL default '',
`url` char( 200 ) NOT NULL default '',
`html` text NOT NULL ,
`createDate` datetime NOT NULL default '0000-00-00 00:00:00',
`modifyDate` datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY ( `id` )

MySQL a répondu:Documentation
#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 '' at line 12

PHP:

thanks

 

place full code of sql file here .

 

thanks for replay this is the full code of sql

 

Execute each create table script seperately, and post which one causes the problem.

I suspect a missing comma or semicolon somewhere...

 

`listingid` int( 11 ) NOT NULL default '',

Code (sql):

I don't think an INT field can have a string as default value. Try 0 instead of ''.

 

the last one he cose probleme

Erreur

requête SQL:

--
-- Table structure for table `cached`
--
CREATE TABLE `cached` (
`id` int( 11 ) NOT NULL AUTO_INCREMENT ,
`listingid` int( 11 ) NOT NULL default '',
`url` char( 200 ) NOT NULL default '',
`html` text NOT NULL ,
`createDate` datetime NOT NULL default '0000-00-00 00:00:00',
`modifyDate` datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY ( `id` )

MySQL a réponduocumentation
#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 '' at line 12

 

i modifed but is the same probleme

Erreur

requête SQL:

-- 
-- Table structure for table `cached`
-- 
CREATE TABLE `cached` (
`id` int( 11 ) NOT NULL AUTO_INCREMENT ,
`listingid` int( 0 ) NOT NULL default '',
`url` char( 200 ) NOT NULL default '',
`html` text NOT NULL ,
`createDate` datetime NOT NULL default '0000-00-00 00:00:00',
`modifyDate` datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY ( `id` )

MySQL a répondu:Documentation
#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 '' at line 12 

Code (markup):

 

You didn't understand what I mean.

`listingid` int( 11 ) NOT NULL default 0,

Code (sql):

 

i change it to this but she gime error

 

Try this above statement. I feel that there is a missing closing )

 

thanks yes is work