173
173
from information_schema.columns
176
create table t1(f1 tinyint, f2 SMALLINT, f3 mediumint, f4 int,
176
create table t1(f1 tinyint, f2 SMALLINT, f3 BIGINT, f4 int,
177
177
f5 BIGINT, f6 TINYINT, f7 SMALLINT);
178
178
select column_name, NUMERIC_PRECISION, NUMERIC_SCALE
179
179
from information_schema.columns