List:General Discussion« Previous MessageNext Message »
From:Dan Nelson Date:September 23 2000 5:27pm
Subject:Re: How are rows inserted in many-to-many relations?
View as plain text  
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
Thread
How are rows inserted in many-to-many relations?Klaus Müller23 Sep
  • Re: How are rows inserted in many-to-many relations?David Tod Sigafoos23 Sep
  • Re: How are rows inserted in many-to-many relations?Dan Nelson23 Sep
    • RE: How are rows inserted in many-to-many relations?Robert Goff23 Sep