# MySQL ERROR 1136 (21S01): Column count doesn't match value count at row 1

**Code:** `1136` · **Category:** SQL · **Seen on:** SQL

An INSERT supplies a different number of values than columns.

## 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.

---
Source: [WhatIsMyError](https://whatismyerror.com/errors/sql/column-count-doesnt-match-value-count)
