I to have about 16 text fields in my db that are NOT NULL and they work fine. Just an observation.
Advertising
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
