author | František Kučera <franta-hg@frantovo.cz> |
Sat, 31 Oct 2020 22:38:32 +0100 | |
branch | v_0 |
changeset 319 | 2a5f26e69a76 |
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!"); |