Revision as of 19:32, 24 May 2024

Internal

Standard SQL INSERT

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

Note: 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'

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 19: / Line 19: @@
 {{Internal|SQL_DELETE#Overview|Standard SQL <tt>DELETE</tt>}}
 <syntaxhighlight lang='sql'>
-DELETE FROM person WHERE "id"=10
+DELETE FROM person WHERE id=10
 </syntaxhighlight>
+Double quotes can be used around column names.
 =<TT>SELECT</TT>=