SQL INSERT

From NovaOrdis Knowledge Base
Revision as of 19:58, 30 May 2024 by Ovidiu (talk | contribs)
Jump to navigation Jump to search

External

Internal

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