1
DROP TABLE IF EXISTS t12;
2
DROP TABLE IF EXISTS t13;
3
CREATE TABLE t12(c1 DECIMAL(5,0) NULL DEFAULT 2);
9
t12 CREATE TABLE `t12` (
10
`c1` decimal(5,0) DEFAULT '2'
11
) ENGINE=ENGINE DEFAULT CHARSET=latin1
15
CREATE TABLE t13(c1 DECIMAL(5,4) NULL DEFAULT 3.1234);
19
SHOW CREATE TABLE t13;
21
t13 CREATE TABLE `t13` (
22
`c1` decimal(5,4) DEFAULT '3.1234'
23
) ENGINE=ENGINE DEFAULT CHARSET=latin1
27
CREATE TABLE t12(c1 DEC(5,0) NULL DEFAULT 2);
31
SHOW CREATE TABLE t12;
33
t12 CREATE TABLE `t12` (
34
`c1` decimal(5,0) DEFAULT '2'
35
) ENGINE=ENGINE DEFAULT CHARSET=latin1
39
CREATE TABLE t13(c1 DEC(5,4) NULL DEFAULT 3.1234);
43
SHOW CREATE TABLE t13;
45
t13 CREATE TABLE `t13` (
46
`c1` decimal(5,4) DEFAULT '3.1234'
47
) ENGINE=ENGINE DEFAULT CHARSET=latin1
51
CREATE TABLE t12(c1 FIXED(5,0) NULL DEFAULT 2);
55
SHOW CREATE TABLE t12;
57
t12 CREATE TABLE `t12` (
58
`c1` decimal(5,0) DEFAULT '2'
59
) ENGINE=ENGINE DEFAULT CHARSET=latin1
63
CREATE TABLE t13(c1 FIXED(5,4) NULL DEFAULT 3.1234);
67
SHOW CREATE TABLE t13;
69
t13 CREATE TABLE `t13` (
70
`c1` decimal(5,4) DEFAULT '3.1234'
71
) ENGINE=ENGINE DEFAULT CHARSET=latin1
75
CREATE TABLE t12(c1 NUMERIC(5,0) NULL DEFAULT 2);
79
SHOW CREATE TABLE t12;
81
t12 CREATE TABLE `t12` (
82
`c1` decimal(5,0) DEFAULT '2'
83
) ENGINE=ENGINE DEFAULT CHARSET=latin1
87
CREATE TABLE t13(c1 NUMERIC(5,4) NULL DEFAULT 3.1234);
91
SHOW CREATE TABLE t13;
93
t13 CREATE TABLE `t13` (
94
`c1` decimal(5,4) DEFAULT '3.1234'
95
) ENGINE=ENGINE DEFAULT CHARSET=latin1
99
CREATE TABLE t12(c1 DECIMAL(5,0) NOT NULL DEFAULT 2);
103
SHOW CREATE TABLE t12;
105
t12 CREATE TABLE `t12` (
106
`c1` decimal(5,0) NOT NULL DEFAULT '2'
107
) ENGINE=ENGINE DEFAULT CHARSET=latin1
111
CREATE TABLE t13(c1 DECIMAL(5,4) NOT NULL DEFAULT 3.1234);
115
SHOW CREATE TABLE t13;
117
t13 CREATE TABLE `t13` (
118
`c1` decimal(5,4) NOT NULL DEFAULT '3.1234'
119
) ENGINE=ENGINE DEFAULT CHARSET=latin1
123
CREATE TABLE t12(c1 DEC(5,0) NOT NULL DEFAULT 2);
127
SHOW CREATE TABLE t12;
129
t12 CREATE TABLE `t12` (
130
`c1` decimal(5,0) NOT NULL DEFAULT '2'
131
) ENGINE=ENGINE DEFAULT CHARSET=latin1
135
CREATE TABLE t13(c1 DEC(5,4) NOT NULL DEFAULT 3.1234);
139
SHOW CREATE TABLE t13;
141
t13 CREATE TABLE `t13` (
142
`c1` decimal(5,4) NOT NULL DEFAULT '3.1234'
143
) ENGINE=ENGINE DEFAULT CHARSET=latin1
147
CREATE TABLE t12(c1 FIXED(5,0) NOT NULL DEFAULT 2);
151
SHOW CREATE TABLE t12;
153
t12 CREATE TABLE `t12` (
154
`c1` decimal(5,0) NOT NULL DEFAULT '2'
155
) ENGINE=ENGINE DEFAULT CHARSET=latin1
159
CREATE TABLE t13(c1 FIXED(5,4) NOT NULL DEFAULT 3.1234);
163
SHOW CREATE TABLE t13;
165
t13 CREATE TABLE `t13` (
166
`c1` decimal(5,4) NOT NULL DEFAULT '3.1234'
167
) ENGINE=ENGINE DEFAULT CHARSET=latin1
171
CREATE TABLE t12(c1 NUMERIC(5,0) NOT NULL DEFAULT 2);
175
SHOW CREATE TABLE t12;
177
t12 CREATE TABLE `t12` (
178
`c1` decimal(5,0) NOT NULL DEFAULT '2'
179
) ENGINE=ENGINE DEFAULT CHARSET=latin1
183
CREATE TABLE t13(c1 NUMERIC(5,4) NOT NULL DEFAULT 3.1234);
187
SHOW CREATE TABLE t13;
189
t13 CREATE TABLE `t13` (
190
`c1` decimal(5,4) NOT NULL DEFAULT '3.1234'
191
) ENGINE=ENGINE DEFAULT CHARSET=latin1