Advanced Search

MySQL - Simulate MySQL Queries

/ Published in: MySQL
Save to your folder(s)
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).

Expand | Embed | Plain Text

Copy this code and paste it in your HTML 
  1. START TRANSACTION;
  2. DELETE FROM my_table WHERE id=101;
  3. ROLLBACK;

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

Report this snippet


Comments

You need to login to view comments.