1136 El recuento de columnas no coincide con el recuento de valores en la fila 1 en el ejemplo de código

Ejemplo 1: ‘El recuento de columnas no coincide con el recuento de valores en la fila 1

-- The error means that you are providing not as much data as the table wp_posts does contain 
-- columns. And now the DB engine does not know in which columns to put your data.
-- To overcome this you must provide the names of the columns you want to fill. Example:

insert into wp_posts (column_name1, column_name2)
values (1, 3)

Ejemplo 2: Insertar lista de valores no coincide con la lista de columnas: 1136 El recuento de columnas no coincide con el recuento de valores en la fila 2 “

In your database table not null columns created are less than the values that
you are passing in the insert query

Example : Assume Your database table has 35 columns
Then,
Where as the values you are passing are 34 columns

This mismatch of columns is giving you the error.
You must have forgot to pass the value for not null column. once you pass 
it error will be resolved

---

---

Utiliza Nuestro Buscador