Making fields unique when there are duplicate rows in mysql
So I had this table working as a many-to-many relationship for some things, with 2 fields, both foreign keys to other tables. Since there for some reason wasn’t anything enforcing uniqueness in the entries, there were several duplicate rows. If I tried to ALTER TABLE to add a primary key to the 2 fields (no [...]