laresistance2 — 2012-01-30T13:16:38-05:00 — #1
All the data in a column of a table of members have been erased, but I made a backup of the table a few weeks ago.
So I need to replace only the data in this column by the old column in the backup of my table.
The problem is that I do not know how I should proceed to do so.
Have you been confronted by this problem and can you explain it to me.
guelphdad — 2012-01-30T14:00:32-05:00 — #2
UPDATE goodtable, backuptable
SET goodtable.somecolumn = backuptable.somecolumn
WHERE goodtable.primarykey = backuptable.primarykey
the somecolumn of course being the name of the column you wanted updated. the primary key being one or more columns in order to identify the rows correctly.
laresistance2 — 2012-02-04T16:13:22-05:00 — #3