1264 🐬 MySQL

MySQL ERROR 1264 (22003): Out of range value for column 'x' at row 1

A number is too large (or negative for UNSIGNED) for the column type.

Seen on: MySQL

Meaning

TINYINT max 127, INT max ~2.1 billion, UNSIGNED rejects negatives. Phone numbers and IDs from external systems often overflow INT.

Common causes

  • Value exceeds the type’s range
  • Negative value into UNSIGNED
  • Phone numbers stored as INT

⚡ Quick fix

  1. Use BIGINT/DECIMAL or VARCHAR for identifiers
  2. Validate ranges
  3. Store phone numbers as strings

Detailed fix by platform

MySQL

  1. ALTER TABLE contacts MODIFY phone VARCHAR(20);

How to diagnose

  1. Value — What value?
  2. Type — Column type and range

🧠 Still stuck? Analyze your error

Paste the full message, response headers or stack trace — we'll detect the platform and point to the most likely cause.