RE: [PHP-DB] modify size of the field
| From: | Eduardo Mena | Date: | Thu, 26 Oct 2000 15:16:20 +0000 |
| Subject: | RE: [PHP-DB] modify size of the field | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-3954@lists.php.net to get a copy of this message | ||
Everything works correctly
Thank you.
Eduardo Mena
Fundación Chasquinet
e-mail: eduardo@chasquinet.org
Quito - Ecuador
----- Original Message -----
From: <php3@developersdesk.com>
To: Eduardo Mena <eduardo@chasquinet.org>; <php-db@lists.php.net>
Sent: Wednesday, October 25, 2000 8:02 PM
Subject: Re: [PHP-DB] modify size of the field
> 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