SQL INSERT: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
|||
| Line 1: | Line 1: | ||
=External= | |||
=Internal= | =Internal= | ||
* [[SQL#INSERT|SQL]] | * [[SQL#INSERT|SQL]] | ||
Revision as of 19:58, 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.