· 6 years ago · Jul 06, 2019, 08:18 AM
1`CREATE TABLE IF NOT EXISTS `testbalNoFieldFormat` (
2 `fig` int(4) NOT NULL,
3 `name` char(10) NOT NULL,
4 `birth` date NOT NULL,
5 `id` char(5) NOT NULL,
6 `salary` double(9,2) NOT NULL DEFAULT 0.00,
7 `dept` int(4) NOT NULL
8) ENGINE=CONNECT DEFAULT CHARSET=utf8 `table_type`=BIN `block_size`=5 `file_name`='TestbalNoFieldFormat.dat'
9
10INSERT INTO testbalNoFieldFormat VALUES(1,"1234567890",'2009-01-20','abcde',100000.12,1234)
11
12" 1 0 0 0 49 50 51 52 53 54 55 56 57 48 32 32
13 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32
14 32 32 48 93 116 73 97 98 99 100 101 32 32 32 32 32
15 32 32 32 32 32 184 30 133 235 1 106 248 64 210 4 0
16 0"
17
18" . . . . 1 2 3 4 5 6 7 8 9 0
19
20 0 ] t I a b c d e
21 ? . ? ? . j ? @ ? . .
22 ."
23
24" 1 875770417 943142453 538980409
25 538976288 538976288 538976288 538976288
26 1563435040 1650542964 543515747 538976288
27 538976288 2233382944 4167696875 315968
28 538976256"