you sure, I use NOT NULL on text fields all the time and it works fine.

Thanks!
--------------------------------------------
-Alex "Big Al" Behrens
E-mail: [EMAIL PROTECTED]
Urgent E-mail: [EMAIL PROTECTED] (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:
[EMAIL PROTECTED]
----- Original Message -----
From: "George Pitcher" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>; "Lisi" <[EMAIL PROTECTED]>
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" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> 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
>
>


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to