Restoring the previous values of 4 rows before updated

PHP
1 
(id)    title          content
(61)   title61      content61
(62)   title62      content62
(63)   title63      content63
(64)   title64      content64

I had myTable like the above.
I have updated 4 records above just some minutes ago by accident.
I have myTable like the below. The values of title and content are all empty except (id) now.

(id)    title          content
(61)   
(62)   
(63)  
(64)

Can I get the original values of the 4 record above with your help?
Can I undo the 4 update queries?

if I can get the 4 values of the column content, I can guess the 4 values of the column title.

2

If you are not in a transaction and you did a straight up update, then no. I am afraid you can’t roll back the change. All you can do is go to a backup, assuming you have one, and pull the data back out of that.

If you have no backup, then I am afraid there is nothing that can be done. :frowning:

3

This topic was automatically closed 91 days after the last reply. New replies are no longer allowed.