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

This article mainly introduces the method of establishing database by mysql, which has certain reference value and can be used for reference by friends who need it. I hope you will learn a lot after reading this article. Next, let the editor take you to learn about it.

1. Log in to the database

Code:

Mysql-u root-p

Enter password

2. Create a database

Code:

Create database test

3. Use the database you just created

Code:

Use test

4. Create a table

Code:

Create table user (id int not null,username varchar (100) not null,password varchar (100) not null,primary key (id))

5. Add a piece of data to the table

Insert into user (id,username,password) values (1)

6. Query data

Code:

Select * from user

Thank you for reading this article carefully. I hope it will be helpful for everyone to share the methods and contents of mysql to build a database. At the same time, I also hope that you will support us, pay attention to the industry information channel, and find out if you encounter problems. Detailed solutions are waiting for you 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.