MySQL Forums
Forum List  »  Newbie

Re: MYsql Error 1136
Posted by: Adhwaith S
Date: September 01, 2023 09:52AM

Hi Zach,

Thank you for the suggestions. The ID field is an AUTO INCREMENT value but i hadn't defined that while creating the table. I did triple check the DDL of the table to check for the structure of the table and the insert script is the correct.

I was able to resolve the issue. Seems like the issue was due to a trigger which was executing a procedure when a record is being inserted or updated . The trigger inserts into another table which was modified(add a new column) and so the insert statement inside the procedure had issue where only 3 column values where specified instead of 4.

Thanks a lot.

Adhwaith S

Options: ReplyQuote

Written By
August 31, 2023 09:52AM
August 31, 2023 04:51PM
Re: MYsql Error 1136
September 01, 2023 09:52AM
September 01, 2023 11:21AM

Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.