Return to Snippet

Revision: 59624
at September 20, 2012 20:29 by satie83


Initial Code
START TRANSACTION;
DELETE FROM my_table WHERE id=101;
ROLLBACK;

Initial URL
http://stackoverflow.com/questions/7581584/simulate-mysql-queries

Initial Description
You could start a transaction before running your queries and then rollback after running them. Note that to do this you'll require InnoDB or XtraDb tables (won't work on MyISAM).

Initial Title
MySQL - Simulate MySQL Queries

Initial Tags
mysql, database, query

Initial Language
MySQL