author | František Kučera <franta-hg@frantovo.cz> |
Mon, 27 Jul 2020 17:51:53 +0200 | |
branch | v_0 |
changeset 310 | aeda3cb4528d |
parent 278 | ae17db13569c |
permissions | -rw-r--r-- |
278
ae17db13569c
examples: Reading SQL scripts
František Kučera <franta-hg@frantovo.cz>
parents:
diff
changeset
|
1 |
CREATE TABLE a ( |
ae17db13569c
examples: Reading SQL scripts
František Kučera <franta-hg@frantovo.cz>
parents:
diff
changeset
|
2 |
id integer, |
ae17db13569c
examples: Reading SQL scripts
František Kučera <franta-hg@frantovo.cz>
parents:
diff
changeset
|
3 |
message varchar |
ae17db13569c
examples: Reading SQL scripts
František Kučera <franta-hg@frantovo.cz>
parents:
diff
changeset
|
4 |
); |
ae17db13569c
examples: Reading SQL scripts
František Kučera <franta-hg@frantovo.cz>
parents:
diff
changeset
|
5 |
|
ae17db13569c
examples: Reading SQL scripts
František Kučera <franta-hg@frantovo.cz>
parents:
diff
changeset
|
6 |
CREATE VIEW b AS SELECT upper(message) AS msg FROM a; |
ae17db13569c
examples: Reading SQL scripts
František Kučera <franta-hg@frantovo.cz>
parents:
diff
changeset
|
7 |
|
ae17db13569c
examples: Reading SQL scripts
František Kučera <franta-hg@frantovo.cz>
parents:
diff
changeset
|
8 |
INSERT INTO a VALUES (1, "Hello,"); |
ae17db13569c
examples: Reading SQL scripts
František Kučera <franta-hg@frantovo.cz>
parents:
diff
changeset
|
9 |
INSERT INTO a VALUES (2, "world!"); |