PHP : How to rollback last query execution in myphpadmin

Question

I have created one table and entered 10 records but one record is having wrong information so i updated that but query went wrong and values are updated in all the records.

So now i want to rollback my previous query execution.

Any help is most welcome!!!

As far as I am aware there is no rollback. Unless you have a backup? — SANM2009, Feb 11 '18 at 21:24
Possible duplicate of [how to undo mysql query?](https://stackoverflow.com/questions/2918831/how-to-undo-mysql-query) — Kevin Pimentel, Feb 11 '18 at 21:40
The only way to rollback is if you use transactions. See this post: https://stackoverflow.com/questions/2918831/how-to-undo-mysql-query — Kevin Pimentel, Feb 11 '18 at 21:41
Truncate the table and start again. This is a development environment, right? — Dan Bracuk, Feb 11 '18 at 21:42

score 3 · Answer 1 · answered Feb 11 '18 at 21:42

3

Unfortunately,
You don't have any chance to rollback last query.
Query log doesn't save no where.

answered Feb 11 '18 at 21:42

Mohammadreza Razzaghi

31
4

PHP : How to rollback last query execution in myphpadmin

1 Answers1