MySQL bulk delete the same prefix table

If you can't run MySQL in the background, go to phpMyAdmin and run a code. If you want to delete the table of the Dede_ prefix of the dream CMS, run

Select CONCAT (' drop table ', table_name, '; ') From Information_schema.tables Where table_name like ' dede_% ';

Then, you'll get a list of queries, then click on select All, and copy down this big bunch of code. re-click the database of the program you installed , and then click on the SQL above, run a copy of the code, note that before deleting all backup.

MySQL bulk delete the same prefix table