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 [mailto:[EMAIL PROTECTED] 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/[EMAIL PROTECTED]