MySQL ERROR 1136 (21S01): Column count doesn't match value count at row 1
An INSERT supplies a different number of values than columns.
Seen on:
SQL
Meaning
Omitting the column list and inserting fewer values, a missing comma, or a schema change adding columns.
Common causes
- INSERT without a column list after the table gained columns
- Missing/extra value
- Missing comma between values
⚡ Quick fix
- Always list columns explicitly in INSERT
- Count values per row
Detailed fix by platform
SQL
INSERT INTO users (email, name) VALUES ('a@b.com', 'Asha');
How to diagnose
- Counts — Columns vs values?
- Recent change — Did it start after a deploy, upgrade, or configuration change? Compare with the last working version.
🧠 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.
Was this page helpful?
Report a correction or suggest an improvement
Last updated 2 Oct 2026