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

In this article Xiaobian for you to introduce in detail "mysql how to view database creation information", the content is detailed, the steps are clear, the details are handled properly, I hope this "mysql how to view database creation information" article can help you solve your doubts, following the editor's ideas slowly in-depth, together to learn new knowledge.

1. Using the command select database (), you can see from the query results that we are not currently entering any database. So for NULL*/.

+-+ | database () | +-+ | NULL | +-+ 1 row in set (0.00 sec)

2. Using the show tables statement, the result of the query is the name of the database currently used.

Mysql > show tables +-+ | Tables_in_test | +-+ | push_test | | ship_order_detail | +-+ 2 rows in set (0.00 sec). This article "how to View Database creation Information by mysql" has been introduced. If you want to master the knowledge of this article, you still need to practice and use it. If you want to know more about the articles, you are 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.