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