2011年4月4日星期一

How to drop multiple tables with common prefix in one query? - Dev Shed

How to drop multiple tables with common prefix in one query? - Dev Shed: "SELECT CONCAT( 'DROP TABLE ', GROUP_CONCAT(table_name) , ';' ) AS statement FROM information_schema.tables WHERE table_name like 'test_%';"

没有评论:

发表评论