adamc@372: table t1 : {A : int, B : string, C : float} adamc@372: adamc@372: val q1 = (SELECT * adamc@375: FROM t1 adamc@372: WHERE A = 0) adamc@373: adamc@373: val a1 = (INSERT INTO t1 adamc@373: VALUES (0, "1", 2.0)) adamc@373: adamc@373: val a2 = (UPDATE t1 adamc@373: SET A = 3, B = "4", C = 5.0) adamc@375: adamc@373: val a3 = (DELETE FROM t1 adamc@373: WHERE B <> "good") adamc@374: adamc@374: adamc@374: val q2 = (SELECT * adamc@374: FROM t1 adamc@374: WHERE A = 0 adamc@374: OR B = "hi" adamc@374: AND (C <> 10.01 adamc@374: OR A = 8) adamc@374: AND (B = B adamc@374: OR B = B adamc@374: AND C = C OR (D = adamc@374: 6 AND 8 = 8)))