How can I undo a mysql statement that I just executed?

by

If you define table type as InnoDB, you can use transactions. You will need set AUTOCOMMIT=0, and after you can issue COMMIT or ROLLBACK at the end of query or session to submit or cancel a transaction. 

ROLLBACK -- will undo the changes that you have made

More Related Contents:

  1. mysql transaction – roll back on any exception
  2. Automatic Rollback if COMMIT TRANSACTION is not reached
  3. MySQL how to fill missing dates in range?
  4. ‘IF’ in ‘SELECT’ statement – choose output value based on column values
  5. Why does MYSQL higher LIMIT offset slow the query down?
  6. How to split the name string in mysql?
  7. Normalization in MYSQL
  8. Is there a REAL performance difference between INT and VARCHAR primary keys?
  9. How to set a maximum execution time for a mysql query?
  10. MySQL select statement with CASE or IF ELSEIF? Not sure how to get the result
  11. Getting around MySQL “Can’t reopen table” error
  12. Can’t Create Entity Data Model – using MySql and EF6
  13. In MySQL, can I copy one row to insert into the same table?
  14. How to copy a row and insert in same table with a autoincrement field in MySQL?
  15. MySQL: Cloning a MySQL database on the same MySql instance
  16. MySQL sharding approaches?
  17. access denied for load data infile in MySQL
  18. Can MySQL convert a stored UTC time to local timezone?
  19. Whats the fastest way to lookup big tables for points within radius MySQL (latitude longitude)
  20. MySQL Workbench: Error in query (1064): Syntax error near ‘VISIBLE’ at line 1
  21. Optimization of MySQL search using “like” and wildcards
  22. Does Order of Fields of Multi-Column Index in MySQL Matter
  23. Alternative to using LIMIT keyword in a SubQuery in MYSQL
  24. NodeJS MySQL Dump
  25. Why do I need “OR NULL” in MySQL when counting rows with a condition
  26. Rank() over Partition by in mysql
  27. Xampp-mysql – “Table doesn’t exist in engine” #1932
  28. Unserialize through query at database level itself
  29. MySQL throws Incorrect string value error
  30. ORDER BY alphabet first then follow by number

Leave a Comment