MYSQL - Warning: Integer display width is deprecated

Viewed 1348

I'm seeing this warning: MYSQL - Warning: #1681 Integer display width is deprecated. MySQL version: 8.0.21

In the past, I had columns with display width (INT(20)) but I removed all of them. As you can see there are no columns with display width:

query:

select count(*), COLUMN_TYPE from information_schema.`COLUMNS`
WHERE COLUMN_TYPE LIKE "%int%"
GROUP by COLUMN_TYPE;

results:

count(*) column_type
    2068 bigint
      96 tinyint(1)
    2285 int
    1267 bigint unsigned
      32 tinyint
      74 int unsigned
       6 smallint unsigned
       1 tinyint unsigned
       1 smallint

As I read, tinyint(1) is ignored: https://dev.mysql.com/doc/relnotes/mysql/8.0/en/news-8-0-19.html

The question is, how I can make this warning go away :)

Thanks in advance!

0 Answers
Related