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
27
28
29
30
31
32
33
34
35
|
X
CREATE TABLE grass_test1 (i1 INTEGER, d1 DOUBLE PRECISION, c1 VARCHAR(20))
X
INSERT INTO grass_test1 VALUES ( 1, 123.456, 'abcd' )
X
INSERT INTO grass_test1 VALUES ( 2, null, 'xxx' )
S
SELECT * FROM grass_test1
1|123.456|abcd
2||xxx
S
SELECT c1 FROM grass_test1 WHERE d1 < 500 / 2 AND i1 <> 2 AND c1 LIKE '%bc%'
abcd
X
INSERT INTO grass_test1 VALUES ( 3, 0.0, '_\''_' )
X
ALTER TABLE grass_test1 ADD COLUMN i2 INTEGER
X
UPDATE grass_test1 SET d1 = 18.6, i2 = 987 WHERE i1 = 2
S
SELECT * FROM grass_test1
1|123.456|abcd|
2|18.6|xxx|987
3|0|_\'_|
X
DROP TABLE grass_test1
|
