Re: How are rows inserted in many-to-many relations?

[Dan Nelson]

In the last episode (Sep 23), Klaus Mller said:
> To insert new rows in A and B is easy. But how is the table A_B updated?
> Do I have to:
>   - lock tables A, B and A_B
>   - insert a row in A and B
>   - insert a row in AB using "last_update_ID" of A and B
>   - unlock all tables

You don't even need the table-locking bit.  Just insert the records.

-- 
	Dan Nelson
	dnelson@stripped