Hi! Thank you for spending the time to read this (:
I have 2 tables:
In normal and correct way, for each user in
user_account (for example [
user_id="123", email="email@example.com", email_validation_id="456"]) there is row in
email_validation (for example
[email_validation_id="456", user_account_id="123", email="firstname.lastname@example.org"]).
But, some things got wrong and now I have users with no email validation. So, I would like to add rows manually: for each user from
user_account which don't have a row in
email_validation (i.e. no row with it's
[email_validation_id=<The current max of (email_validation.email_validation_id) + 1>, user_account_id=<user_account.user_id>, email=<user_account.email>] and update the
I have no idea how to approach this :\
Thank you for your time!