Skip to main content

INSERT

Learn INSERT (CRUD Operations, MySQL) with worked examples, diagrams and interview questions. Free on JavaSchoolLab.

Introduction INSERT adds new rows to a table. You can list the target columns and supply one or many value tuples, copy rows from a query with INSERT ... SELECT , or set columns by name with INSERT ... SET . Columns you leave out get their DEFAULT, their AUTO_INCREMENT value, or NULL.

More lessons in CRUD Operations