what alternative to transactions do you use in mysql? in oracle, i can generate a sequence ID and then use that as an ID in my 2 tables and if all this fails, i can rollback. but in mysql, i think i can only auto_increment a field in a table, and use this as a sequence (by getting the max from the selected table??) -- so how do i make sure that the sequence is the one just created by a particular user, and not the one created by another user on another machine?
alternative to transactions in mysql?
- Thread starter wxdqz
- Start date