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 1 year ago
Was this helpful?