SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
05-07-2008, 10:15 AM
| ||||
| ||||
 Insert ... select Hi all, Apologies if this isn't the correct list but I couldn't see a more suitable one. I have 4 tables. t1 and t3 are a many to many relationship and use t2 as link table. t3 has many t4. What I want to do is insert a new row into t3 for each row in t1. I then want to add the corresponding row in the link table and also add optional rows in t4 that refer to the new row in t3. I hope this makes some sense. I could do this with PHP fairly simply but I'm wondering if something like this is possible in sql as then I can add it to my db migrations. Regards Dan      |
Linear Mode
