Needed to simulate some DELETE’s on one of our production databases. After thinking about backup/restore and such time consuming things I found this :
CREATE TEMPORARY TABLE test_tbl SELECT * FROM table_to_test;
This table stays until you drop it or close your mysql-admin session.
Great….