Re: Error creating new table

you sure, I use NOT NULL on text fields all the time and it works fine. Thanks! -------------------------------------------- -Alex "Big Al" Behrens E-mail: bigal@3d-unlimited.com Urgent E-mail: bigal-cell@3d-unlimited.com (Please be brief!) Phone: 651-482-8779 Cell: 651-329-4187 Fax: 651-482-1391 ICQ: 3969599 Owner of the 3D-Unlimited Network: http://www.3d-unlimited.com Send News: news@3d-unlimited.com ----- Original Message ----- From: "George Pitcher" <fmdev@yahoo.co.uk> To: <php-db@lists.php.net>; "Lisi" <lists@shemeshdirectory.co.il> Sent: Monday, April 08, 2002 3:13 AM Subject: Re: [PHP-DB] Error creating new table > You can't have NOT NULL assigned to a text field. > > george > ----- Original Message ----- > From: "Lisi" <lists@shemeshdirectory.co.il> > To: <php-db@lists.php.net> > Sent: Monday, April 08, 2002 10:11 AM > Subject: [PHP-DB] Error creating new table > > > > 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 > > > > > > -- > > 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 > >