mass replace of values in more tables by a highest value
- by nescius
Hello, I have a table with OWN_ID and OWN_Email -
3ace7cf80edd | email@example.com
3acf6af33ff7 | email@example.com
3acda2524e00 | email@example.com
3ad75583c9a7 | spam@example.com
3ad74b018999 | spam@example.com
etc.
the problem is that it should contain only a single ID per Email, also I need to replace all OWN_ID…
