Just a quick question relating to the use of transactions on
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?