How to use Mysql to manage relational database

The first step is to install MySQL

Before using MySQL, you need to install MySQL first. You can download the MySQL installation program from the official MySQL website https://dev.mysql.com/downloads/mysql/ and follow the prompts to complete the installation process. During the installation process, you can set the root user password and port and other related information.

Second step, connect to MySQL

Once the installation is completed, you can use the client program provided by MySQL to establish a connection with the MySQL server. You can choose a variety of different clients to operate, such as MySQL Workbench, Navicat, or use the command line. This article uses the command line method as an example. Enter the following command on the command line to connect to the MySQL server:

mysql -u root -p

The -u parameter is used to specify the user name for the connection, and the -p parameter is used to prompt for a password. When specifying the server address and port, if the port number is set, the -h parameter can be used.

The third step, manage the MySQL server

After the connection is successful, you can start to manage the MySQL server, including creating, modifying and deleting databases, as well as adding and modifying and operations such as deleting tables.

1. Create database

To create a new database in the MySQL server, you can use the CREATE DATABASE statement. For example, the following command will create a database named mydatabase:

CREATE DATABASE mydatabase;

2. Using the database

To use the database you have created, you need to use USE statement. For example, the following command will use the database named mydatabase:

USE mydatabase;

3. Create table

You can use the CREATE TABLE statement to create a new table in the MySQL server data sheet. For example, the following command will create a table named mytable:

CREATE TABLE mytable (
id INT(11) NOT NULL AUTO_INCREMENT,
name VARCHAR(255) NOT NULL,
age INT(11) NOT NULL,
PRIMARY KEY (id)
);

This command creates a table named mytable and defines columns such as id, name and age, where the id column is auto-incrementing and as Primary key.

4. Insert data

You can insert data into a table in the MySQL server by using the INSERT INTO statement. For example, the following command will insert a record into the mytable table:

INSERT INTO mytable (name, age) VALUES ('Tom', 20);

5. Query data

You can use the SELECT statement to query the table in the MySQL server The data. For example, the following command will return all records in the mytable table:

SELECT * FROM mytable;

6. Modify data

You can use the UPDATE statement to modify table data in the MySQL server. Jerry will be set as the new name for the record with age 20 in the table mytable using the following command:

UPDATE mytable SET name='Jerry' WHERE age=20;

7. Delete data

You can use the DELETE statement on the MySQL server to delete data from a table. For example, the following command will delete records with age 20 in the mytable table:

DELETE FROM mytable WHERE age=20;

8. Deleting tables and databases

You can use the DROP TABLE statement in Delete the table on the MySQL server. For example, the following command will delete a table named mytable:

DROP TABLE mytable;

To delete a database on a MySQL server, use the DROP DATABASE statement. For example, the following command will delete the database named mydatabase:

DROP DATABASE mydatabase;

The above is the detailed content of How to use Mysql to manage relational database. For more information, please follow other related articles on the PHP Chinese website!