Re: MYsql Error 1136

[Zach Ellis]

Hello Adhwaith S

I'm new to mysql dba. IF someone more qualified comes ignore my help and go with them.

If ID is an auto increment value you can omit it read page 352 or go to 3.6.9 Using AUTO_INCREMENT or input null or 0 and it will continue with the next number in sequence.

double check the structure of the table with describe table or show create table. Recreate the insert statement after looking at the output of the describe table do it without the script and show me as well.

their might be a miss placed delimiter that is confusing the db and its reading what supposed to be two values but reading it as one or vise versa.

articles about the error

https://forums.mysql.com/read.php?10,652406,652406#msg-652406

https://database.guide/fix-error-1136-21s01-column-count-doesnt-match-value-count-at-row-1-when-inserting-data-in-mysql/

https://www.databasestar.com/column-count-doesnt-match-value-count/

if the database is not confidential create a sql dump of it and paste it in you response so i can use it to try and recreate the problem and also the script.

hope this helps
Zach Ellis