SQL INSERT

Internal

• SQL

Overview

INSERT INTO person (id, name) VALUES (1, 'Binh Ngo');

PostgreSQL

MySQL

The column names and the values provided must correspond in number and type. The INSERT statement may not contain a WHERE clause, because there is no previous data for this row WHERE may apply to.

Conditional INSERT

Also see: Template:SQL WHERE