MySQL INSERT Statement: A Comprehensive Guide with Examples

The MySQL INSERT statement is used to insert data into a table. The syntax for the INSERT statement is as follows:

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

Here, 'table_name' is the name of the table where data needs to be inserted, and 'column1', 'column2', 'column3', etc. are the names of the columns in the table. The 'VALUES' keyword is used to specify the values that need to be inserted into each column.

For example, let's say we have a table named 'employees' with the following columns: 'id', 'name', 'age', and 'salary'. To insert a new employee into the table, we can use the following INSERT statement:

INSERT INTO employees (id, name, age, salary)
VALUES (1, 'John Doe', 25, 50000);

This will insert a new row into the 'employees' table with the values '1' for the 'id' column, 'John Doe' for the 'name' column, '25' for the 'age' column, and '50000' for the 'salary' column.

We can also insert multiple rows into a table using a single INSERT statement. For example:

INSERT INTO employees (id, name, age, salary)
VALUES (2, 'Jane Smith', 30, 60000),
       (3, 'Bob Johnson', 35, 70000),
       (4, 'Sarah Lee', 28, 55000);

This will insert three new rows into the 'employees' table with the specified values for each column.