MySQL INSERT INTO

MySQL INSERT INTO Statement

The INSERT INTO statement in MySQL is used to add new records (rows) into a table.

Syntax:

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

• table_name → The name of the table where data is inserted.
• (column1, column2, column3) → The columns where values will be inserted.
• VALUES (value1, value2, value3) → The actual values to insert.

Demo Database

Below is a selection from the "Students" table in the school_db database:

Inserting a Record

• Adds a student named John Doe, aged 20, from New York into the Students table.

Inserting Multiple Records at Once

• Inserts three students in one query.

Inserting Data Without Specifying Columns

• Works only if you provide values for all columns in the correct order.

Insert Data Only in Specified Columns

In MySQL, you don’t have to insert data into all columns of a table. You can specify only the columns you want to insert values into, and the rest will either:

✅ Take their default value (if defined).

✅ Remain NULL (if allowed).

Syntax:

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

• Columns not mentioned will be set to NULL or their default value.

• gender will be default value (Male). Other columns will be null.

The selection from the "Students" table will now look like this: