MySQL数据库中的数据类型及其长度和小数点

最新推荐文章于 2022-07-21 15:09:08 发布

Geek-SX

最新推荐文章于 2022-07-21 15:09:08 发布

阅读量1k

点赞数 1

分类专栏： MySQL JavaEE

本文链接：https://blog.csdn.net/IT_world_/article/details/117290814

版权

JavaEE 同时被 2 个专栏收录

14 篇文章 1 订阅

订阅专栏

MySQL

2 篇文章 0 订阅

订阅专栏

// 有小数点
List<String> decimalList = Arrays.asList("DECIMAL","DOUBLE","FLOAT","NUMERIC","REAL");
// 无小数点数据类型
List<String> noDecimalList = Arrays.asList("BIGINT","BINARY","BIT","CHAR","DATETIME","INT","INTEGER","VARCHAR",
                "TINYBLOB","TINYTEXT","TEXT","MEDIUMBLOB","MEDIUMINT","MEDIUMTEXT", "LONGBLOB","LONGTEXT","SMALLINT",
                "TIME","TIMESTAMP","TINYINT","VARBINARY");
// 无小数点无长度数据类型
List<String> noDecimalAndLengthList = Arrays.asList("BLOB","DATE","ENUM","GEOMETRY","GEOMETRYCOLLECTION","JSON",
                "LINESTRING","LONGBLOB","LONGTEXT","MEDIUMBLOB","MEDIUMTEXT","MULTILINESTRING","MULTIPOINT",
                "MULTIPOLYGON","POINT","POLYGON","SET","TINYBLOB","TINYTEXT","YEAR");