Revision as of 19:31, 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

Standard SQL SELECT

SELECT "id", "name" FROM person

@@ Line 6: / Line 6: @@
 {{Internal|SQL_INSERT#Overview|Standard SQL <tt>INSERT</tt>}}
 <syntaxhighlight lang='sql'>
-INSERT INTO person ("id", "name") VALUES (10, 'Bob')
+INSERT INTO person (id, name) VALUES (10, 'Bob')
 </syntaxhighlight>
+Note: Use single quotes for the string values. Double quotes will let the SQL interpreter think you use a column name.
 =<TT>UPDATE</TT>=