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

  1. Always list columns explicitly in INSERT
  2. Count values per row

Detailed fix by platform

SQL

  1. INSERT INTO users (email, name) VALUES ('a@b.com', 'Asha');

How to diagnose

  1. Counts — Columns vs values?
  2. 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.