Simulate mysql queries

Question

Is there a way to test the mysql queries, without modifying my database?

For example, can I run a delete from my_table where id=101 without actual delete anything? What about insert and update?

TY

Answer 1

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).

To start a transaction send to MySQL the following statement:

START TRANSACTION; 

And at the end of your queries run the following statement:

ROLLBACK; 

Your database will never be modified from the point of view of other connections. Your current connection will see the changes until ROLLBACK, and after that the original state will be restored.

Answer 2

If you just want to see how many rows would be deleted why not substitute 'delete' with 'select count(*)'?