Archive

Archive for February, 2011

SQL “simulate” a DELETE statement

February 24th, 2011 No comments

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

Categories: Information Technology Tags: ,