sql - Error with mysql (error 1136) -

sql - Error with mysql (error 1136) -

i've got little problem database.

i have created table 'articoli' contains brand, model , cost of articles.

every article defined id (id_articolo)` auto increment field.

well when seek insert data, don't specify id because auto increment, have got error says:

"error sql (1136): column count doesn't match value count @ row 1".

that means forget field, , 1 don't specify on query id. why error if id auto increment field?

if insert statement doesn't provide all columns, need explicitly list columns are providing, if 1 you're leaving out auto-incrementing:

insert articoli (brand, model, price) values ('mybrand', 'mymodel', 100)

mysql sql database