Latest revision as of 19:32, 24 May 2024

Internal

Standard SQL INSERT

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

Double quotes can be used around column names.

Use single quotes for the string values. Double quotes will let the SQL interpreter think you use a column name.

Standard SQL UPDATE

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

Double quotes can be used around column names.

Standard SQL DELETE

DELETE FROM person WHERE id=10

Double quotes can be used around column names.

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>
+Double quotes can be used around column names.
+Use single quotes for the string values. Double quotes will let the SQL interpreter think you use a column name.
 =<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>
+Double quotes can be used around column names.
 =<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>
+Double quotes can be used around column names.
 =<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>