PostgreSQL DML Operations: Difference between revisions
Jump to navigation
Jump to search
(→SELECT) |
|||
| Line 1: | Line 1: | ||
=Internal= | =Internal= | ||
* [[PostgreSQL Operations]] | * [[PostgreSQL Operations]] | ||
* [[SQL#SQL_Data_Statements_(DML)|SQL Data Statements (DML)]] | |||
=<TT>INSERT</TT>= | =<TT>INSERT</TT>= | ||
Revision as of 22:47, 22 May 2024
Internal
INSERT
INSERT INTO TEST ("ID", "NAME") VALUES (10, 'Bob')
UPDATE
UPDATE TEST SET "ID"=50 WHERE "NAME"='Bob'
DELETE
DELETE FROM TEST WHERE "ID"=10
SELECT
SELECT "ID", "NAME" FROM TEST