I'm able to rollback unwanted edits to a mySQL table with Java but
I notice that the primary key ( id INT UNSIGNED NOT NULL
AUTO_INCREMENT PRIMARY KEY) does increment although the rollback is
successful.
In other words, if the PRIMARY KEY is 100 and user rollsback on
three records then the next insert will generate 104 rather than a
nice and neat 101. I wanted to know if this behavior can be handled
or do us developers just "live with it".
Does it work any different from Terminal if you just enter the SQL
there, is it mysql or java?
Your primary key should just ensure uniqueness shouldn't it? It
wouldn't be anything you would select or report on so it doesn't
really matter much does it?
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Java-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
http://lists.apple.com/mailman/options/java-dev/email@hidden
