advanced code snippet search

Posted By

satie83 on 09/20/12


Tagged

mysql database query


Versions (?)

MySQL - Simulate MySQL Queries

 / Published in: MySQL
 

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

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 
  1. START TRANSACTION;
  2. DELETE FROM my_table WHERE id=101;
  3. ROLLBACK;

Report this snippet  

You need to login to post a comment.