I'm using phpMyAdmin to create a new table for my news publishing script that I am working on.
myadmin generates this code...
CREATE TABLE news (
id SMALLINT( 10 ) DEFAULT '0' NOT NULL AUTO_INCREMENT ,
topic VARCHAR( 50 ) NOT NULL ,
author VARCHAR( 15 ) NOT NULL ,
date DATE( 10 ) NOT NULL ,
news TEXT( 1000 ) NOT NULL ,
PRIMARY KEY ( news )
) )
generates this error...
MySQL said:
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 '(10) NOT NULL, news TEXT(1000) NOT NULL, PRIMARY KEY (id))'
