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

This article mainly introduces the method of building mysql database, the article is very detailed, has a certain reference value, interested friends must read it!

Mysql database building method: first install and download mysql, and open cmd;, and then type mysqld to start the mysql server; then view all the current databases; finally, create the database with the code [create database database name;].

How to build a database in mysql:

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

2. View all the current databases: show databases

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

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

Switch the current database to test_db

Command use test_db

5. Create the table TB_USER, and then use show tables to check whether the table is created successfully.

The above are all the contents of the method of building mysql database, thank you for reading! Hope to share the content to help you, more related knowledge, 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.