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.