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

The following mainly brings you 7 steps to complete the mysql database operation, I hope these contents can bring you practical use, this is also the main purpose of this article that I edit the 7 steps to fix the mysql database operation. All right, don't talk too much nonsense, let's just read the following.

1. Connect to the database

Mysql-uroot-p123456

two。 Show database

Show databases

3. Open / switch database

Use mysql

4. Show data sheet

Show tables

5. Display table structure

Desc user

6. Query data

Select * from user

7. Create a database

Create database chartset utf-8

For the above 7 steps to complete the mysql database operation, we do not think it is very helpful. If you need to know more, please continue to follow our industry information. I'm sure you'll like 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.