MySQL ODBC Connector - Alter table

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Alter table

Yemi Obembe

2006-01-02, 11:23 am

------ =_Part_1573_29588897
.1136217784677
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

one of my table columns is unique. i mean cant av duplicate contents. How d=
o
i remove this?

------ =_Part_1573_29588897
.1136217784677--

ISC Edwin Cruz

2006-01-02, 11:23 am

ALTER TABLE db.table DROP INDEX nameOfTheIndex;

If you don't know "nameOfTheIndex" use:
Show create table db.table

Regards!

-----Mensaje original-----
De: Yemi Obembe & #91;mailto:kehers@gm
ail.com]=20
Enviado el: Lunes, 02 de Enero de 2006 10:03 a.m.
Para: mysql@lists.mysql.com
Asunto: Alter table

one of my table columns is unique. i mean cant av duplicate contents. =
How do
i remove this?

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql? unsub...sie.nctu.edu.tw

Sponsored Links