For the record, the problem was assigning a length to a text field. The NOT NULL part is fine.
Thanks everyone for your input! -Lisi At 04:59 PM 4/8/02 -0700, Jennifer Downey wrote: >I to have about 16 text fields in my db that are NOT NULL and they work >fine. >Just an observation. > >Jennifer > >"Lisi" <[EMAIL PROTECTED]> wrote in message >[EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > > 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 > > > >-- >PHP Database Mailing List (http://www.php.net/) >To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
