3150
MySQLWARNINGCriticalDeprecationHIGH confidence
Integer display width is deprecated
Production Risk
Low — warning only; no functional change until removal.
What this means
The display width attribute for integer types (e.g., INT(11)) is deprecated in MySQL 8.0.17 and has no functional effect. It will be removed in a future version.
Why it happens
- 1CREATE TABLE or ALTER TABLE specifying integer display widths like INT(11), BIGINT(20).
How to reproduce
trigger — this will error
trigger — this will error
CREATE TABLE t1 (id INT(11));
expected output
Warning (Code 3150): Integer display width is deprecated and will be removed in a future release.
Fix
Remove the display width
Remove the display width
CREATE TABLE t1 (id INT);
Why this works
The display width attribute has always been cosmetic only; removing it has no functional impact.
What not to do
✕
Version notes
MySQL 8.0.17
Display width for integer types deprecated; TINYINT(1) exception for boolean compatibility maintained.
Sources
Official documentation ↗
MySQL 8.0 — 3150 ER_WARN_DEPRECATED_INTEGER_DISPLAY_WIDTH2
Content generated with AI assistance and reviewed for accuracy. Found an error? hello@errcodes.dev