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

This article mainly explains "how to view the current database in MySQL". Interested friends may wish to have a look at it. The method introduced in this paper is simple, fast and practical. Let's let the editor take you to learn how to view the current database by MySQL.

MySQL view the current database

(1) there are three ways to check which database is currently used under MySQL.

Use the select database () statement

Mysql > select database ()

+-+

| | database () |

+-+

| | test |

+-+

1 row in set (0.00 sec)

As can be seen from the query results, the test database is currently used.

(2) use the show tables statement to query the result, the first behavior Tables_in_XXX, here XXX is

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)

As you can see from the query results, the test database is currently being used.

(3) using the status statement, one line of the query result is currrent database: XXX. Here's XXX.

Is the name of the database currently used.

Mysql > status

-

Mysql Ver 14.14 Distrib 5.1.60, for pc-linux-gnu (i686) using EditLine wrapper

Connection id: 1484237

Current database: test

Current user: root@localhost

SSL: Not in use

As you can see from the query results, the test database is currently being used.

At this point, I believe you have a deeper understanding of "how to view the current database in MySQL". You might as well do it in practice. Here is the website, more related content can enter the relevant channels to inquire, follow us, continue to learn!

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.