1426
MySQLerrorddlhigh confidence
Too big precision for column
Production Risk
Low — DDL fails; no data affected.
What this means
The precision (M) specified for a DECIMAL, FLOAT, or DOUBLE column exceeds the maximum allowed value (65 for DECIMAL).
Why it happens
- 1Defining DECIMAL(70, 2) — precision 70 exceeds max 65
How to reproduce
trigger — this will error
trigger — this will error
CREATE TABLE t (price DECIMAL(70, 2));
expected output
ERROR 1426 (42000): Too big precision 70 specified for column 'price'. Maximum is 65
Fix
Reduce precision to 65 or less
Reduce precision to 65 or less
CREATE TABLE t (price DECIMAL(65, 2));
Why this works
DECIMAL maximum precision is 65 digits.
Sources
Official documentation ↗
MySQL 8.0 — 1426 ER_TOO_BIG_PRECISION
Content generated with AI assistance and reviewed for accuracy. Found an error? hello@errcodes.dev