I accidentally deleted all values in a column of a table in my database. The table contains tracks, and added_by is a string specifying who added the track.
I have now restored an old backup of the database as
old_database with the table
old_tracks. The current version is called
database and the table is
I would like to restore the values of each addedby field, but this doesn't work out for me:
UPDATE tracks SET added_by = `old_database`.`old_tracks`.`added_by` WHERE id = `old_database`.`old_tracks`.`id`;
Can you help me do it the right way?
Thanks a lot.