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

This article uses easy-to-understand examples to introduce the method of viewing the database under the linux environment. The content of the article is compact step by step. I hope you can get something according to this article.

First enter the following command:

Mysql-uroot-p

Enter the root password to enter the mysql.

Check the steps for details:

1. Display the database

Show databases

2. Select a database

Use database name

3. Display the tables in the database

Show tables

4. Display the structure of the data table

Describe table name

5. Display the records in the table

SELECT * FROM table name

6. Build a database

Create databse library name

After reading this article, have you learned how to view the database in linux environment? If you want to learn more skills or want to know more about it, you are welcome to follow the industry information channel. Thank you for reading.

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.