I have a problem with a database. Well, there are lots of problems with this database but I am struggling to make it function at the moment without errors.
The problem is that when the tables were designed, the developer did not make the right fields Primary or unique. This means that on a particular table, with members of an organisation, a field contains many duplicate values. This in turn leads to problems because some of the PHP relies on this field to update information.
The table in question appears not to have a primary key at all, it does specify unique for a different field (which should have been designated the Primary Key at the design stage, but which wasn’t)
There are many things wrong with this database, enum fields etc, but I am trying to resolve this critical problem at the moment.
The table is in a real mess with duplicates of on field causing problems. Is there any way I can do the following easily.