Database Design Question...

2003-06-18 Thread NIPP, SCOTT V (SBCSI)
Hello... I am currently working on a User Account Management system. I am actually a Unix SA who is moonlighting at work as a MySQL DBA and web developer. I am learning a lot and enjoying the work, but I am severely lacking in database design fundamentals. I have created a couple very

Changing column from UNIQUE?

2002-05-03 Thread NIPP, SCOTT V (SBCSI)
I have a column in a table that is currently configured as UNIQUE. I have recently discovered that some duplicates may exist in this column, so I want to remove the UNIQUE flag on this column. How? Thanks. sql Scott Nipp Systems Analyst SBC