SQL INSERT

INSERT

Syntax

INSERT [LOW_PRIORITY | DELAYED | HIGH_PRIORITY] [IGNORE]
 [INTO] tbl_name [PARTITION (partition_list)] [(col,...)]
 {VALUES | VALUE} ({expr | DEFAULT},...),(...),...
 [ ON DUPLICATE KEY UPDATE
   col=expr
     [, col=expr] ... ] [RETURNING select_expr
      [, select_expr ...]]
		    

Examples

INSERT INTO employees (employee_id, first_name, last_name, month_salary, job_title, reports_to, office_id)
VALUES (54231, "JERRY", "LEE",110000, "Junior Executive", 37270,3),
       (54232, "TOM", "WONG",120000, "Junior Executive", 37270,3);