blob: 958fb070dba3a655e287378c82309ca251272e5c (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
|
table t1 : {A : int, B : string, C : float}
val q1 = (SELECT *
FROM t1
WHERE A = 0)
val a1 = (INSERT INTO t1
VALUES (0, "1", 2.0))
val a2 = (UPDATE t1
SET A = 3, B = "4", C = 5.0)
val a3 = (DELETE FROM t1
WHERE B <> "good")
val q2 = (SELECT *
FROM t1
WHERE A = 0
OR B = "hi"
AND (C <> 10.01
OR A = 8)
AND (B = B
OR B = B
AND C = C OR (D =
6 AND 8 = 8)))
|
