Shulou(Shulou.com)05/31 Report--

This article introduces the relevant knowledge of "what are the problems related to MySQL FQA". In the actual case operation process, many people will encounter such difficulties. Next, let Xiaobian lead you to learn how to deal with these situations! I hope you can read carefully and learn something!

After dropping a database, do you still need to create corresponding users and permissions?

A: No, because MySQL users and permissions are stored in the mysql database, drop a database, these statements will not have an impact.

2. I want to delete all the tables in a database, but I don't want to use drop database. What should I do?

A: First, use the following statement to generate all drop table name statements:

SELECT concat('DROP TABLE IF EXISTS `', table_name, '`;')FROM information_schema.tables WHERE table_schema = 'db_name';

Then execute the following statement:

SET FOREIGN_KEY_CHECKS = 0; Executes the query statement

Last Reply Foreign Key Check:

SET FOREIGN_KEY_CHECKS = 1;"What are the problems related to MySQL FQA" is introduced here. Thank you for reading. If you want to know more about industry-related knowledge, you can pay attention to the website. Xiaobian will output more high-quality practical articles for everyone!

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.