MySQL Forums
Forum List  »  Newbie

Re: MYsql Error 1136
Posted by: Zach Ellis
Date: August 31, 2023 04:51PM

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,652406,652406#msg-652406

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

Options: ReplyQuote

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