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

How does mysql build a library? This problem may be often seen in our daily study or work. I hope you can gain a lot from this question. The following is the reference content that the editor brings to you, let's take a look at it!

How does mysql build a database?

1. Download mysql, install, then open cmd,cd to the directory where mysql is located, and type mysqld to start the mysql server

two。 View all current databases: show databases

3. Create the database: create database database name; (here you create the test_db database, and then view all databases with the 1 command)

4.

Now that the database is created, the next step is to create the database table. For example, we create a table called tb_user in test_db, which contains fields email and password.

5. Switch the current database to test_db

Command use test_db

6. Create the table TB_USER, and use show tables to see if the table is created successfully.

Thank you for reading! After reading the above, do you have a general understanding of how to build the database of mysql? I hope the content of the article will be helpful to all of you. If you want to know more about the relevant articles, you are 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.