How can I use insert in mysql to add data to a table?

To add data to a table in MySQL using the INSERT statement, you can follow these steps:

1. Open the MySQL command line tool or MySQL client.
2. Select the specified database;
3. Insert data using the INSERT INTO statement with the following syntax:

INSERT INTO table_name (column1, column2, column3, ...)
VALUES (value1, value2, value3, ...);

In the above syntax, table_name is the name of the table where data will be inserted, column1, column2, column3 are the column names for the data to be inserted, value1, value2, value3 are the values to be inserted.

例如，如果要向一个名为students的表中插入一条数据，可以使用以下命令：

INSERT INTO students (name, age, grade)
VALUES ('Alice', 18, 'A');

This will insert a record into the students table with the value of ‘Alice’ in the name column, 18 in the age column, and ‘A’ in the grade column.

1. Execute the INSERT statement to insert data into the table.

By following the above steps, you can use the INSERT statement in MySQL to add data to a table.