EC
1463
MySQLERRORNotableDDLHIGH confidence

Display width out of range for column

Production Risk

Low — DDL error; the table will not be created.

What this means

ER_TOO_BIG_DISPLAYWIDTH (1463, SQLSTATE HY000) is raised when the display width specified for a numeric column exceeds the maximum allowed value.

Why it happens
  1. 1INT(300) or similar with a display width exceeding the maximum allowed (255)
  2. 2Misunderstanding display width as storage size
How to reproduce
trigger — this will error
trigger — this will error
CREATE TABLE t (
  id INT(300)  -- Display width 300 exceeds max of 255
);

expected output

ERROR 1463 (HY000): Display width out of range for column 'id' (max = 255)

Fix

Use a valid display width or omit it

Use a valid display width or omit it
-- Omit display width (recommended):
CREATE TABLE t (id INT);

-- Or use a valid width:
CREATE TABLE t (id INT(11));

Why this works

Display width for integer types must be between 1 and 255. In MySQL 8.0.17+, integer display width is deprecated.

Version notes
MySQL 8.0.17+

Integer display width is deprecated; omitting it is recommended.

Sources
Official documentation ↗

MySQL 8.0 — 1463 ER_TOO_BIG_DISPLAYWIDTH

Content generated with AI assistance and reviewed for accuracy. Found an error? hello@errcodes.dev

← All MySQL errors