Error

MySQL said: You have an error in your SQL syntax near 'NOT NULL ,author VARCHAR NOT NULL ,publisher VARCHAR NOT NULL ,ISBN VARCHAR N' at line 1.

Query: CREATE TABLE TechBooks(title VARCHAR NOT NULL ,author VARCHAR NOT NULL ,publisher VARCHAR NOT NULL ,ISBN VARCHAR NOT NULL )

seems oddly formed... Wouldn't it be title VAR CHAR NOT NULL, author...?

Hi I'm really stupid, it has taken me years to admit this but I'm a total moron... please flame me until I am charred and all ashen...

VAR CHAR wants a limit of course.

Hi,

It seems that you didn't select the lenght of Varchar type.

Cheers,

Cheers,

Dat

Programming and creating plugins and templates
Blog