select concat('drop table ',table_name,';') from information_schema.tables where table_name like 'RecordMst2012%'
结果集合粘出来放入notepad ctrl+H替换| 然后执行
或者
mysql -s -N -uroot -pxxx -e "select concat('drop table ',table_name,';') from information_schema.tables where table_name like 'RecordMst2012%'" > test.sql
mysql dbname1 < test.sql