| Syntax definition |
Example |
SELECT [predicate]
{ * |table.* | [table.]field_1 [AS alias_2] [, [table.]field_2 [AS alias_2] [, ...]]}
FROM statement [, ...]
[WHERE... ]
[GROUP BY... ]
[HAVING... ]
[ORDER BY... ]
|
select A as "Value", B as "Sum"
from MyTable
where A>B and A>0
order by B |
|
INSERT syntax for add one record:
INSERT INTO table [(field_1[, field_2[, ...]])]
VALUES (value_1[, value_2[, ...])
Syntax for subquery based INSERT:
INSERT INTO table [(field_1[, field_2[, ...]])]
SELECT [source.]field_1[, field_2[, ...] FROM-expression |
insert into MyTable (A,B)
values (5,80) |
DELETE [table.*]
FROM table
WHERE selection_condition |
delete from MyTable
where A>470 |
UPDATE table
SET { field = expression_for_new_value }
[WHERE selection_condition] |
update MyTable
set A=40
where A<25 |
|
DROP <object type> <object name>
Object types: table, view, index, etc. |
drop table MyTable |
CREATE TABLE <table name>
( field_description,... [CONSTRAINT <constraint>])
<field description> ::= <field name> <field type>
<constraint> ::= <constraint_name> PRIMARY KEY (<fields name list>) |
create table MyTable
( A integer,
B decimal
) |
GRANT statement[,...]
TO account[,...]
or
GRANT permission[,...]
ON object[,...]
TO account[,...] |
GRANT DROP DATABASE, CREATE TABLE
TO Mary, Peter
GRANT INSERT, UPDATE, DELETE
ON Rating
TO Tom |
REVOKE statement[,...]
FROM account[,...]
or
REVOKE permission[,...]
ON object[,...]
FROM account[,...] |
REVOKE CREATE TABLE
FROM Mary
REVOKE INSERT
ON Rating
FROM Tom |