Revision as of 23:26, 22 May 2024

Internal

Standard SQL INSERT

INSERT INTO person ("id", "name") VALUES (10, 'Bob')

Standard SQL UPDATE

UPDATE person SET "id"=50 WHERE "name"='Bob'

Standard SQL DELETE

DELETE FROM person WHERE "id"=10

Standard SQL SELECT

SELECT "id", "name" FROM person

@@ Line 1: / Line 1: @@
 =Internal=
 * [[PostgreSQL Operations]]
+* [[SQL#SQL_Data_Statements_(DML)|SQL Data Statements (DML)]]
 =<TT>INSERT</TT>=
+{{Internal|SQL_INSERT#Overview|Standard SQL <tt>INSERT</tt>}}
 <syntaxhighlight lang='sql'>
-INSERT INTO TEST ("ID", "NAME") VALUES (10, 'Bob')
+INSERT INTO person ("id", "name") VALUES (10, 'Bob')
 </syntaxhighlight>
 =<TT>UPDATE</TT>=
+{{Internal|SQL_UPDATE#Overview|Standard SQL <tt>UPDATE</tt>}}
 <syntaxhighlight lang='sql'>
-UPDATE TEST SET "ID"=50 WHERE "NAME"='Bob'
+UPDATE person SET "id"=50 WHERE "name"='Bob'
 </syntaxhighlight>
 =<TT>DELETE</TT>=
+{{Internal|SQL_DELETE#Overview|Standard SQL <tt>DELETE</tt>}}
 <syntaxhighlight lang='sql'>
-DELETE FROM TEST WHERE "ID"=10
+DELETE FROM person WHERE "id"=10
 </syntaxhighlight>
 =<TT>SELECT</TT>=
+{{Internal|SQL_SELECT#Overview|Standard SQL <tt>SELECT</tt>}}
 <syntaxhighlight lang='sql'>
-SELECT "ID", "NAME" FROM TEST
+SELECT "id", "name" FROM person
 </syntaxhighlight>