Error creating new table
| From: | Lisi | Date: | Mon, 08 Apr 2002 09:11:13 +0000 |
| Subject: | Error creating new table | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-18310@lists.php.net to get a copy of this message | ||
I am trying to create the following table using PHPMyAdmin:
CREATE TABLE IF NOT EXISTS ayny(
organization varchar(50) NOT NULL,
subtitle varchar(50) NOT NULL,
img varchar(20) NOT NULL,
width varchar(5),
height varchar(5),
link varchar(30) NOT NULL,
maintext text(50) NOT NULL,
boxtext text(50) NOT NULL,
ID INT(9) NOT NULL AUTO_INCREMENT,
PRIMARY KEY(ID)
);
But I keep getting the following error:
MySQL said: You have an error in your SQL syntax near '(50) NOT NULL, boxtext text(50) NOT NULL, ID INT(9) NOT NULL AUTO_INCREMENT,' at line 8
Any ideas what I'\m doing wrong?
TIA,
-Lisi