SQL INSERT: Difference between revisions
Jump to navigation
Jump to search
| (One intermediate revision by the same user not shown) | |||
| Line 16: | Line 16: | ||
=Conditional <tt>INSERT</tt>= | =Conditional <tt>INSERT</tt>= | ||
Also see: {{ | Also see: {{Internal|SQL_Conditional_Logic#Overview|SQL Conditional Logic}} | ||
Latest revision as of 21:10, 30 May 2024
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
Also see: