Fwd: Question relating to transactions on innodb tables.

[Machiel Richards - Gmail]

Hi All

        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?

Regards
Machiel