Re: modify size of the field
| From: | php3 at developersdesk dot com | Date: | Thu, 26 Oct 2000 01:02:16 +0000 |
| Subject: | Re: modify size of the field | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-3903@lists.php.net to get a copy of this message | ||
Addressed to: "Eduardo Mena" <eduardo@chasquinet.org>
php-db@lists.php.net
** Reply to note from "Eduardo Mena" <eduardo@chasquinet.org> Wed, 25 Oct 2000
09:43:52 -0500
>
> ------=_NextPart_000_0037_01C03E68.15CC3800 Content-Type: text/plain;
> charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
>
> Hi everybody.
>
> When carrying out the change of the size of the field ' nombre' obtains =
> the following error:=20
>
> mysql> alter table telecen_inv modify nombre varchar(100); ERROR 1121:
> Column 'nombre' is used with UNIQUE or INDEX but is not = defined as L
> mysql>
>
> How I can solve this problem.
ALTER TABLE telecen_inv MODIFY nombre VARCHAR(100) NOT NULL;
Rick Widmer
Internet Marketing Specialists
www.developersdesk.com