Home > Information Technology > SQL “simulate” a DELETE statement

SQL “simulate” a DELETE statement

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.


Categories: Information Technology Tags: ,
  1. No comments yet.
  1. No trackbacks yet.