Tag Archives: drop

MySQL : drop table with prefix

SELECT CONCAT( 'DROP TABLE ', GROUP_CONCAT(table_name) , ';' ) 
    AS statement FROM information_schema.tables 
    WHERE table_schema = 'nama_pengkalandata' AND table_name LIKE 'namaprefix_%';

run those SQL in mysq terminal or phpmyadmin or any mysql client. It will generate ‘drop table’ syntax.

ref: http://stackoverflow.com/questions/1589278/sql-deleting-tables-with-prefix

Advertisements