SQL INSERT: Difference between revisions
Jump to navigation
Jump to search
Tag: Manual revert |
|||
| Line 12: | Line 12: | ||
|- | |- | ||
|} | |} | ||
The <code>INSERT</code> statement may not contain a <code>[[SQL_WHERE#Overview|WHERE]]</code> clause. | The column names and the values provided must correspond in number and type. The <code>INSERT</code> statement may not contain a <code>[[SQL_WHERE#Overview|WHERE]]</code> clause. | ||
Revision as of 00:14, 23 May 2024
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.