如何将ID从一个表更新到另一个表 [英] how to update id from one table to another

问题描述

我有两个表:

• TABLE1具有列(id，name，password)，
• TABLE2具有列(id，salary，dept).

• TABLE1 has columns(id,name,password),
• TABLE2 has columns(id,salary,dept).

id是自动生成的序列号.数据使用Java表单添加.我想在table2中显示table1 id以及其他详细信息.

id in table1 is auto-generated sequence number. Data is added using java form. I wanted to show table1 id in table2 along with other details.

create or replace PROCEDURE PRO5(y in varchar,z in varchar,x in varchar,
                                c in varchar,d in varchar,b in number, j in number)
as BEGIN
    insert into emp_general(username,email,password) values(y,z,x);
    insert into SALARY_DET(username ,salary,company,dept) values(y,c,d,b);

    set j := INSERT INTO salary_det(ID) SELECT ID FROM emp_general;
END;

推荐答案

尝试一下，

 select @Id = convert(int,scope_identity());

对于Oracle

 SET LID = LAST_INSERT_ID();

这篇关于如何将ID从一个表更新到另一个表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！