MySQL - Simulate MySQL Queries - MySQL Snipplr Social Repository

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

Choose a language for easy browsing: