Re: Error creating new table

I to have about 16 text fields in my db that are NOT NULL and they work fine. Just an observation. Jennifer "Lisi" <lists@shemeshdirectory.co.il> wrote in message news:5.0.0.25.0.20020408110854.00a199f0@web.maxinvest.com... > 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 > --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.344 / Virus Database: 191 - Release Date: 4/2/2002