Hello,
I have two tables. They are linked with foreign key. How can i copy row
with all subrows into the same tables?
For example, i have
table1(id,title):
1,"title1".
table2(id,table1_id,name):
1,1,"name1",
2,1,"name2",
3,1,"name3".
I want to copy first row in table 1 and get following result:
table1(id,title):
1,"title1",
2,"title1".
table2(id,table1_id,name):
1,1,"name1",
2,1,"name2",
3,1,"name3",
4,2,"name1",
5,2,"name2",
6,2,"name3".
How can i do this using sql queries from database side (not from
application side)? And in general case table2 either can contain subrows
from (for example) table3.
Is it possible? and is solution is graceful?
Thanks,
Denis.