| author | František Kučera <franta-hg@frantovo.cz> |
| Sat, 11 Jan 2020 20:30:54 +0100 | |
| branch | v_0 |
| changeset 291 | 2fab532bda09 |
| 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!"); |