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

Editor to share with you how to query the library name of mysql, I believe that most people do not know much about it, so share this article for your reference, I hope you can learn a lot after reading this article, let's go to understand it!

Mysql query library name method: 1, use the "show databases;" statement to query the library name; 2, use the status statement to query, such as "currrent database:***", where * * is the current database name.

This article operating environment: Windows7 system, mysql5.6 version, Dell G3 computer.

You can view the database name in two ways:

1. Use the show databases; statement

2. Using the status statement, one line of the query result is currrent database:***. Here * * is the name of the current database.

1. Open the mysql console and enter your password

2. To enter the database, you must first enter show databases.

3. Which database to use, you must first enter a use + table name such as use nowasp

4. If you want to know which tables are in this database, enter the command show + step 3 of the database. Such as show nowasp

5. After that, you can use a large number of SQL statements to manipulate the tables you need, so as to achieve the purpose of learning sql statements, such as viewing the data in the table select * from accounts

The above is all the contents of the article "how to query the Library name of mysql". 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.