更新时间:2023-01-29 13:14:26
您可以使用触发器。
使用游标您可以从一个表中获取记录并首先将该记录提取到游标中并使用游标上的循环可以更新多个表记录。
how to update in multiple tables from one table updation with the primary and foreign key concept
Hi,
You can use Triggers for same.
using cursor you can take record from one table and fetch that record into cursor first and using the loop on cursor you can update multiple tables record.