Insert query in MySQL

MySQL INSERT
In MySQL, the INSERT statement is used to insert a single record or multiple records into a table in a database.

Syntax:

INSERT into table_name(column_1, column_2, ... column_n )  
VALUES(value1, value2, .. valuen);  

Example 1: MySQL INSERT single record insertion:
Items table before insertion:

ID NAME QUANTITY
1 Electronics 30
2 Sports 45
INSERT INTO items  
(id, name, quantity)  
VALUES  
(3, 'Fashion’, 100);

Explanation:
The ‘items’ is an already existing table with some records. Here we are inserting a new row under the respective columns with the corresponding values: 3, ‘Fashion’ and 100.

Items table after insertion:

ID NAME QUANTITY
1 Electronics 30
2 Sports 45
3 Fashion 100

Example 2: MySQL INSERT partial record insertion:
Items table before insertion:

ID NAME QUANTITY
1 Electronics 30
2 Sports 45
INSERT INTO items  
(id, name)  
VALUES  
(3, 'Fashion’);

Explanation:
The ‘items’ is an already existing table with some records. Here we are inserting a new row with the corresponding values: 3 and ‘Fashion’ in the ‘id’ and ‘name’ columns respectively.

Items table after insertion:

ID NAME QUANTITY
1 Electronics 30
2 Sports 45
3 Fashion NULL

Example 3: MySQL INSERT multiple record insertion:
Items table before insertion:

 

ID NAME QUANTITY
1 Electronics 30
2 Sports 45
INSERT INTO items  
(id, name, quantity)  
VALUES  
(3, 'Fashion’, 100)
(4, ‘Grocery’, 90)
(5, ‘Toys’, 50);

Explanation:
The ‘items’ is an already existing table with some records. Here we are inserting multiple new records under the respective columns with the corresponding values.

Items table after insertion:

ID NAME QUANTITY
1 Electronics 30
2 Sports 45
3 Fashion 100
4 Grocery 90
5 Toys 50
Please Share