[kenfused]

In trying to setup a MySQL database thru phpMyAdmin (a "SITEMAPPER" script from HOTSCRIPTS...)

I entered the SQL txt text into the MySQL commands:

SQL-query : [Edit]

CREATE TABLE /*!32300 IF NOT EXISTS*/ section (
sectionID int(3) NOT NULL auto_increment,
parentID int(3) NOT NULL DEFAULT \'0\' ,
title varchar(255) NOT NULL DEFAULT \'\' ,
content text ,
PRIMARY KEY (sectionID),
INDEX title (title)
);

MySQL said:


You have an error in your SQL syntax near '\'0\' ,
title varchar(255) NOT NULL DEFAULT \'\' ,
content text ,
PRIMA' at line 3


Does anyone know what the error is?
What does it mean?
Thanks

[Cagez]

You put quotes around the 0 making it a string, but the field is a int.

[kenfused]

Thanks! Got it!

[Cagez]

No problemo.