Geografic-Information-System/scripts/db.test/test1

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 ~ '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