MySQL Forums
Forum List  »  Newbie

MYsql Error 1136
Posted by: Adhwaith S
Date: August 31, 2023 09:52AM

Operation failed: There was an error while applying the SQL script to the database.
INSERT INTO `adhwaith`.`expenses` (`ID`, `category`, `amount`, `on_date`) VALUES ('40', 'Temple Expense', '500', '2023-08-10');

ERROR 1136: 1136: Column count doesn't match value count at row 1
SQL Statement:
INSERT INTO `adhwaith`.`expenses` (`ID`, `category`, `amount`, `on_date`) VALUES ('40', 'Temple Expense', '500', '2023-08-10')

The column count is 4 and the values are for the 4 columns but am still getting the error. Can someone please help me on how can I resolve this error since the column count is actually correct.

Options: ReplyQuote

Written By
MYsql Error 1136
August 31, 2023 09:52AM
August 31, 2023 04:51PM
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.