數字型別
CREATE TABLE all_numeric_types(
c_tinyint tinyint,
c_smallint smallint,
c_int int,
c_bigint bigint,
c_decimal decimal(38,3)
);
最小和最大資料值:
insert into all_numeric_types values (-128,-32768,-2147483648,-9223372036854775808,-99999999999999999999999999999999999.999);
insert into all_numeric_types values (127,32767,2147483647,9223372036854775807,99999999999999999999999999999999999.999);