deadlock for mixed row and table lock?

[Andrew Nuss]

Hi,

Using InnoDB. 2 Tables, call them A and B, which are used in conjunction to define my "tree" relationships. I always make sure in all transactions to update A and THEN update B.

However, in many:

I do row updates on rows of A (sorted by id) (row lock) and then inserts on B (assume table lock) while in others I do inserts on A (assume table lock) and then updates on rows of B (sorted by id).

Am I safe against deadlock?

Andy