mysql8.0.19中在navicat客户端中int、bigint等类型设置长度保存后为0

最新推荐文章于 2024-02-28 21:47:22 发布

黄大侠98k

最新推荐文章于 2024-02-28 21:47:22 发布

阅读量1.5k

点赞数

分类专栏：数据库文章标签： mysql

本文链接：https://blog.csdn.net/huangxingjie/article/details/115401649

版权

数据库专栏收录该内容

3 篇文章 0 订阅

订阅专栏

官网相关资料：

MySQL Server 8.0.17 deprecated the display width for the TINYINT, SMALLINT, MEDIUMINT, INT, and BIGINT data types when the ZEROFILL modifier is not used, and MySQL Server 8.0.19 has removed the display width for those data types from results of SHOW CREATE TABLE, SHOW CREATE FUNCTION, and queries on INFORMATION_SCHEMA.COLUMNS, INFORMATION_SCHEMA.ROUTINES, and INFORMATION_SCHEMA.PARAMETERS (except for the display width for signed TINYINT(1)). This patch adjusts Connector/J to those recent changes of MySQL Server and, as a result, DatabaseMetaData, ParameterMetaData, and ResultSetMetaData now report identical results for all the above-mentioned integer types and also for the FLOAT and DOUBLE data types. (Bug #30477722)

根据官网资料可知：从8.0.17版本开始，TINYINT, SMALLINT, MEDIUMINT, INT, and BIGINT类型的显示宽度将失效。