NIPP,
Friday, May 03, 2002, 9:16:01 PM, you wrote:
Neoen> I have a column in a table that is currently configured as UNIQUE.
Neoen> I have recently discovered that some duplicates may exist in this column, so
Neoen> I want to remove the UNIQUE flag on this column. How? Thanks.
If you define column as UNIQUE you can't add duplicate values in the
column.
Use DROP INDEX statement or ALTER TABLE.
Description of their syntax you can find in the manual:
http://www.mysql.com/doc/D/R/DROP_INDEX.html
http://www.mysql.com/doc/A/L/ALTER_TABLE.html
>> Scott Nipp
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Egor Egorov
/ /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED]
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net
<___/ www.mysql.com
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
