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
Attachment: [application/pgp-signature] OpenPGP digital signature signature.asc