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

This article will explain in detail how to view the database about mysql. The quality of the article is high, so Xiaobian shares it with you for reference. I hope you have a certain understanding of relevant knowledge after reading this article.

How to view MySQL database

1. Enter MySQL

root@test# mysql -u root -p

2. Query Library

mysql> show databases;

3. Enter the library

mysql> use student;

student: library name

4. Query table

mysql> show tables;

MySQL is a relational database management system, developed by MySQL AB in Sweden, which belongs to Oracle's products. MySQL is one of the most popular relational database management systems, and in terms of WEB applications, MySQL is one of the best RDBMS (Relational Database Management System) applications. MySQL is a relational database management system that stores data in different tables rather than storing all data in one large repository, which increases speed and flexibility.

About mysql how to view the database to share here, I hope the above content can be of some help to everyone, you can learn more knowledge. If you think the article is good, you can share it so that more people can see it.

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.