Micke
Reputation: 2406
Update one table with newly inserted id from another
So, the situation is this:
- Table Foo has a foreign key to table Bar.
- There are currently many rows in Foo where this foreign key is null.
- All Foos need a Bar.
I want to:
- For each Foo where bar_fk is null, insert a new row into Bar.
- Update Foo with the newly added id for Bar.
How would you do this in MySQL? Can it be done using straight SQL? Using stored procedures?
Upvotes: 0
Views: 225
Answers (1)
Related Questions
- update the id of a value in one mysql table which is the actual in another my sql table
- MYSQL Insert id from another table
- Sql insert id from one table to entry in another
- Insert ID from one table to another in MySQL php
- MySQL update details in table 1 from table 2 where ID matches
- MySQL update table based on id in another table
- update table with data from another table where ids match
- Inserting an ID from one table into another when a new record is inserted
- update second table with the autoincremented id of the first table
- MYSQL INSERT INTO existing table data FROM 2 separate tables ON id