MySQL Forums
Forum List  »  InnoDB

No Insert/Update on InnoDB (Myisam works)
Posted by: Bas Schlepers
Date: May 27, 2014 11:35AM

Without going in to much details yet, I have a problem (major atm).
I have a database which was running in the past. However for a new project I needed a database environment so reused my old environment.

All well, however I can create tables (myisam and innodb). After creation I can add 1 record using the INSERT INTO in a myisam table.
However the same action on an innodb is impossible (if I use the sql browser).

If I connect the innodb table to access by ODBC link I can open the innodb table and start adding rows.... STrange. Now something even stranger.
If I user an auto increment field and add the data only to an fake extra column. I can see the increment on my ID column. When I use the query browser nothing happens (at least it seems). If I then use the access environment the increment has made 1 step but there is no record...

Can someone help me on the right track how to solve this.

Just tested in an other database at home and that one is working perfect.

Options: ReplyQuote


Subject
Views
Written By
Posted
No Insert/Update on InnoDB (Myisam works)
1498
May 27, 2014 11:35AM


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.