drop the index on that column and then add a non-unique index. NIPP, SCOTT V (SBCSI) wrote:
> Sorry for posting a slightly off topic question, but I am having >trouble figuring out how to do something basic. I have a MySQL database >that has a UNIQUE column in a table. My problem is that I need to change >the column to non-UNIQUE. I cannot figure out how to do this through the >mysql monitor. I know this should be a simple ALTER TABLE statement, or >something similar but I can't figure out exactly how to do this. Thanks in >advance, and sorry again for posting off topic. > >> Scott Nipp >> Systems Analyst >> SBC Long Distance >> (214) 858-1289 >> >>
