How should the “insert” function be used in MySQL?

10 months ago

Liam

1 minute

In MySQL, data is inserted using the INSERT INTO statement. The syntax format is as follows:

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

In this case, table_name is the name of the table where data will be inserted, column1, column2, column3, etc. are the names of the columns where data will be inserted, and value1, value2, value3, etc. are the corresponding values for each column.

Suppose there is a table called students, with columns id, name, and age, we want to insert a record into it:

INSERT INTO students (id, name, age)
VALUES (1, 'Alice', 20);

This inserted a record into the students table with the id as 1, name as Alice, and age as 20.