Shulou(Shulou.com)06/01 Report--

Editor to share with you mysql delete all the tables in the library method, I believe that most people do not understand, so share this article for your reference, I hope you will learn a lot after reading this article, let's go to know it!

Mysql deletes all tables in the library by directly executing the [SELECT table_name FROM information_schema.tables WHERE table_schema = 'mydb';] statement.

Execute the following SQL statement directly on the command line:

SELECT concat ('DROP TABLE IF EXISTS', table_name,';') FROM information_schema.tablesWHERE table_schema = 'mydb'

Description: mydb represents the database name of the table to be deleted.

The above is all the contents of mysql's method of deleting all the tables in the library. Thank you for reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more knowledge, welcome to follow the industry information channel!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.