MySQL Forums
Forum List  »  Performance

Re: Values not inserting into MySQL Database table
Posted by: Shan Abdussalam
Date: November 11, 2015 12:49PM

I do raise exceptions for all errors and as such, the transaction should roll back I think?

But the point is that, why does this query fail in inserting data at a particular time, but when executed later manually seem to work fine. There is nothing wrong with the query as such, what I would like to know is if there could be something happening in the database at that instance that prevented the record insertion from taking place. And if so, what is the best way to find and rectify this.

I use Innodb engine by the way.

Options: ReplyQuote

Written By
Re: Values not inserting into MySQL Database table
November 11, 2015 12:49PM

Sorry, you can't reply to this topic. It has been closed.

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.