Am 25.11.2011 14:20, schrieb Machiel Richards - Gmail: > Just a quick question relating to the use of transactions on innodb tables. > > We are doing some archiving on some innodb tables, however there seems to be > some issues somewhere in the > process with data not being updated accordingly. > > We would like to make use of transactions for this , in order to allow us to > roll back on changes if the > after checks does not correspond. > > What I am trying to find out is whether a transaction will cause the locks to > be handled as table locks or > will it be row level locks?
which locks about you are speaking? a transaction is a transaction a lock is a lock
signature.asc
Description: OpenPGP digital signature