MYSQL insert

For this example, we will use the table(users).

Insert single record

INSERT INTO table_name(field1_name, field2_name)VALUES(value1, value2);

Example

INSERT INTO users(first_name, last_name, address)VALUES("Ram", "Singh", "Delhi");

Insert multiple records

INSERT INTO table_name(field1_name, field2_name)VALUES(value1, value2), (value1, value2), (value1, value2);

Example

INSERT INTO users(first_name, last_name, address)
VALUES("Krishna", "Singh", "Delhi"),
("Mohit", "Singh", "Delhi"),
("Swayam", "Singh", "Delhi"),
("Shailly", "Singh", "Delhi");