RE: [PHP-DB] Error creating new table
| From: | Rick Emery | Date: | Mon, 08 Apr 2002 21:37:24 +0000 |
| Subject: | RE: [PHP-DB] Error creating new table | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-18327@lists.php.net to get a copy of this message | ||
The problem is that he assigned a length to a TEXT field. You cannot do
that.
-----Original Message-----
From: George Pitcher [mailto:fmdev@yahoo.co.uk]
Sent: Monday, April 08, 2002 3:13 AM
To: php-db@lists.php.net; Lisi
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