_ _
___ | |__ __ _ _______ | |_
/ _ \| '_ \ / _` |_ / _ \| __|
| (_) | | | | (_| |/ / (_) | |_
\___/|_| |_|\__,_/___\___/ \__|
sql_admin —
SQL admin
[CREATE|DROP] DB_ELEMENT [IF [NOT]
EXISTS] ELEMENT_NAME;
| DB element |
: can be table, view, trigger. |
| Exists |
: create if item does not exist or drop if it exists. |
(back to top)
| insert |
: INSERT INTO <TABLE_NAME>(<COLUMNS>)
VALUES(<VALUES>); |
| update |
: UPDATE <TABLE_NAME> SET <COLUMN_NAME> =
<VALUE>; |
| delete |
: DELETE FROM <TABLE_NAME> WHERE
<CONDITION>; |
(back to top)
CREATE TABLE <TABLE_NAME> (
COLUMN_NAME1 DATA_TYPE,
COLUMN_NAME2 DATA_TYPE
);
Queries can be saved as views: create view
VIEW_NAME as QUERY;
Specify action to be executed on events:
create trigger TRIGGER_NAME [BEFORE|AFTER] [EVENT]
begin
STATEMENT
end;
EVENT can be:
| insert |
: INSERT ON <TABLE_NAME> |
| update |
: UPDATE OF <COLUMN_NAME> ON
<TABLE_NAME> |
| delete |
: DELETE ON <TABLE_NAME> |
Field references can be:
| insert |
: new.COLUMN_NAME |
| update |
: new.COLUMN_NAME and old.COLUMN_NAME |
| delete |
: old.COLUMN_NAME |
Example
CREATE TRIGGER <TRIGGER_NAME> AFTER INSERT on <TABLE_NAME> begin
UPDATE <TABLE1_NAME> set <COLUMN_NAME> = new.<COLUMN_NAME>;
end;