Welcome to the new platform of Programmer's Heaven! We apologize for the inconvenience caused, if you visited us from a broken link of the previous version. The main reason to move to a new platform is to provide more effective and collaborative experience to you all. Please feel free to experience the new platform and use its exciting features. Contact us for any issue that you need to get clarified. We are more than happy to help you.
I have 2 tables T1 and T2.
What is happening now is, when I insert a row in T1, I insert a row in T2 with all the exact parameters
as T1 and the last 3 as sponsor_ssn = 000000000 and is_special_time = 1 and link = 1
Now, I want to add a new column to T1 called "ak" which is varchar(50) and a new column to T2 called
"webid" which is also varchar(50). Basically I want to have some sort of primary key foreign key relationship
from T1 --> T2.
Now, I have already added the "ak" column to T1 with some unique values. I want to add the same values
corresponding rows in T2 in column "webid".
What will be the best way to do this? I understand that there will be some sort of update query,but
I can't seem to figure that out.
Thanks for your help.
0 · ·