MySQL deletes all table methods in the database

MySQL Delete all table method technology in database

Maybe yes posted on 2015-01-23 12:16

Original link: http://blog.lmlphp.com/archives/66 from: lmlphp backyard

Output the database table name and the SQL statement that needs to be executed by using the CONCAT function, and then copy the contents from the console, paste, execute, OK. The Table_schema condition is the database name that needs to be manipulated, and the reference SQL statement is as follows:

SELECT CONCAT (' DROP TABLE IF EXISTS ', table_name, '; ') From Information_schema.tableswhere table_schema = ' lmlphp ';

Read (63) reviews (0) View comments

MySQL deletes all table methods in the database