Insert

  • INSERT INTO <table_name> (column_name_list) VALUES (value_list)

INSERT INTO `table_name`(`column1`, `column1`, `column1`)
VALUES ("value 1", "value 2", "value 3");
INSERT INTO `table_name`
VALUES ("value 1", "value 2", "value 3");
INSERT INTO `table_name`(column1, column1, column1)
VALUES ("value 11", "value 12", "value 13"),
("value 21", "value 22", "value 23"),
("value 31", "value 32", "value 33"),
("value 41", "value 42", "value 43");

Last updated