2 echo CREATE TABLE t1
(f1 int default
1,f2 smallint default
10,f3 bigint default
100,f4 float default
1.9,f5 double default
987654321.123456,f6 char
(20) default
'CSQl-CACHE',f7
date default
'2001-01-01',f8
time default
'01:01:01',f9 timestamp default
'2001-01-01 01:01:01');
4 echo INSERT INTO t1
(f1
) VALUES
(9);
5 Statement Executed
: Rows Affected
= 1
6 echo INSERT INTO t1
(f2
) VALUES
(999);
7 Statement Executed
: Rows Affected
= 1
8 echo INSERT INTO t1
(f3
) VALUES
(999999);
9 Statement Executed
: Rows Affected
= 1
10 echo INSERT INTO t1
(f4
) VALUES
(9.9);
11 Statement Executed
: Rows Affected
= 1
12 echo INSERT INTO t1
(f5
) VALUES
(123456789.987654);
13 Statement Executed
: Rows Affected
= 1
14 echo INSERT INTO t1
(f6
) VALUES
('TCSQL-MMDB');
15 Statement Executed
: Rows Affected
= 1
16 echo INSERT INTO t1
(f7
) VALUES
('2009-06-09');
17 Statement Executed
: Rows Affected
= 1
18 echo INSERT INTO t1
(f8
) VALUES
('21:09:09');
19 Statement Executed
: Rows Affected
= 1
20 echo INSERT INTO t1
(f9
) VALUES
('2009-06-09 21:09:09');
21 Statement Executed
: Rows Affected
= 1
22 echo SELECT
* FROM t1
;
23 ---------------------------------------------------------
24 t1.f1 t1.f2 t1.f3 t1.f4 t1.f5 t1.f6 t1.f7 t1.f8 t1.f9
25 ---------------------------------------------------------
26 9 10 100 1.900000 987654321.123456 CSQl-CACHE
2001/1/1 1:1:1.0 2001/1/1 1:1:1.0
27 1 999 100 1.900000 987654321.123456 CSQl-CACHE
2001/1/1 1:1:1.0 2001/1/1 1:1:1.0
28 1 10 999999 1.900000 987654321.123456 CSQl-CACHE
2001/1/1 1:1:1.0 2001/1/1 1:1:1.0
29 1 10 100 9.900000 987654321.123456 CSQl-CACHE
2001/1/1 1:1:1.0 2001/1/1 1:1:1.0
30 1 10 100 1.900000 123456789.987654 CSQl-CACHE
2001/1/1 1:1:1.0 2001/1/1 1:1:1.0
31 1 10 100 1.900000 987654321.123456 TCSQL-MMDB
2001/1/1 1:1:1.0 2001/1/1 1:1:1.0
32 1 10 100 1.900000 987654321.123456 CSQl-CACHE
2009/6/9 1:1:1.0 2001/1/1 1:1:1.0
33 1 10 100 1.900000 987654321.123456 CSQl-CACHE
2001/1/1 21:9:9.0 2001/1/1 1:1:1.0
34 1 10 100 1.900000 987654321.123456 CSQl-CACHE
2001/1/1 1:1:1.0 2009/6/9 21:9:9.0