2 echo create table t1
(f1 char
(10), f2 tinyint
, f3 smallint
,f4 int
, f5 bigint
,f6 integer
, f7 float
, f8 real
,f9 double
,f10 long
,f11 binary
(128),f12
date,f13
time,f14 timestamp
);
4 echo insert into t1 values
('NIHAR', 1,1,-2147483648,9223372036854775807, 2147483648,1.1, 1000000000.000000,10000001.10000001,99999,'ABCDEF0123456789','2001-1-1', '01:01:01', '2001-11-30 01:01:01');
5 Statement Executed
: Rows Affected
= 1
7 ---------------------------------------------------------
8 t1.f1 t1.f2 t1.f3 t1.f4 t1.f5 t1.f6 t1.f7 t1.f8 t1.f9 t1.f10 t1.f11 t1.f12 t1.f13 t1.f14
9 ---------------------------------------------------------
10 NIHAR
1 1 -2147483648 9223372036854775807 2147483647 1.100000 1000000000.000000 10000001.100000 99999 ABCDEF0123456789
2001/1/1 1:1:1.0 2001/11/30 1:1:1.0
12 echo insert into t1 values
(NULL
,NULL
,NULL
,NULL
,NULL
,NULL
,NULL
,NULL
,NULL
,NULL
,NULL
,NULL
,NULL
,NULL
);
13 Statement Executed
: Rows Affected
= 1
14 echo select * from t1
;
15 ---------------------------------------------------------
16 t1.f1 t1.f2 t1.f3 t1.f4 t1.f5 t1.f6 t1.f7 t1.f8 t1.f9 t1.f10 t1.f11 t1.f12 t1.f13 t1.f14
17 ---------------------------------------------------------
18 NIHAR
1 1 -2147483648 9223372036854775807 2147483647 1.100000 1000000000.000000 10000001.100000 99999 ABCDEF0123456789
2001/1/1 1:1:1.0 2001/11/30 1:1:1.0
19 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
21 echo UPDATE t1
set f1
='PAPU', f2
=10, f3
=2, f4
=2147483647, f5
=-9223372036854775808, f6
=-2147483647, f7
=10.01, f8
=2000000002.000002, f9
=20000002.200002, f10
=2147483647, f11
='9876543210DcAbEf', f12
='2003-3-3', f13
='03:03:03', f14
='2003-3-3 03:03:03';
22 Statement Executed
: Rows Affected
= 2
23 echo select * from t1
;
24 ---------------------------------------------------------
25 t1.f1 t1.f2 t1.f3 t1.f4 t1.f5 t1.f6 t1.f7 t1.f8 t1.f9 t1.f10 t1.f11 t1.f12 t1.f13 t1.f14
26 ---------------------------------------------------------
27 PAPU
10 2 2147483647 9223372036854775807 2147483647 10.010000 2000000002.000002 20000002.200002 2147483647 9876543210DCABEF
2003/3/3 3:3:3.0 2003/3/3 3:3:3.0
28 PAPU
10 2 2147483647 9223372036854775807 2147483647 10.010000 2000000002.000002 20000002.200002 2147483647 9876543210DCABEF
2003/3/3 3:3:3.0 2003/3/3 3:3:3.0
30 echo UPDATE t1
set f1
=NULL
, f2
=NULL
, f3
=NULL
, f4
=NULL
, f5
=NULL
, f6
=NULL
, f7
=NULL
, f8
=NULL
, f9
=NULL
, f10
=NULL
, f11
=NULL
, f12
=NULL
, f13
=NULL
, f14
=NULL
;
31 Statement Executed
: Rows Affected
= 2
32 echo select * from t1
;
33 ---------------------------------------------------------
34 t1.f1 t1.f2 t1.f3 t1.f4 t1.f5 t1.f6 t1.f7 t1.f8 t1.f9 t1.f10 t1.f11 t1.f12 t1.f13 t1.f14
35 ---------------------------------------------------------
36 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
37 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
40 Statement Executed
: Rows Affected
= 2
41 echo select * from t1
;
42 ---------------------------------------------------------
43 t1.f1 t1.f2 t1.f3 t1.f4 t1.f5 t1.f6 t1.f7 t1.f8 t1.f9 t1.f10 t1.f11 t1.f12 t1.f13 t1.f14
44 ---------------------------------------------------------