simulate a query

[TheJuice]

Hi, I'd like to know if it's possible to execute a query in MySQL, without it really beaing executed: just to know if it would return something, but not actually doing anything to the database.

I have may deletes to do on different tables with relations, and I would like to test the delete functions first, without actually deleting anything. Because I would have to re-insert data each time I test the function...

Thanks.

[dnszero]

I'm not sure that's actually possible or not.

I usually just do an equivalent SELECT statement and check to see if returns what I expect. Then as long as your syntax is correct everything should be just fine.

HTH

[TheJuice]

good idea. thanks
Should work indeed.

[dnszero]

BTW, just had one other thought, you could use transactions. Just BEGIN, run your querry, then ROLLBACK. Not all MySQL versions and table types support transactions, though. But that would be the most accurate and complete way to be 100% sure that it would work.