TB_TEST_ONE 表信息
TB_TEST_TWO(设置ID,SQE为主键)
alter table TB_TEST_TWO add constraint TB_TEST_TWO_PK primary key (ID,SQE)
插入数据:
INSERT INTO TB_TEST_TWO (ID,NAME,AGE,SQE)
SELECT ID,NAME,AGE,(SELECT 1 FROM DUAL )
FROM TB_TEST_ONE
TB_TEST_TWO表插入后的信息
TB_TEST_ONE 表信息
TB_TEST_TWO(设置ID,SQE为主键)
alter table TB_TEST_TWO add constraint TB_TEST_TWO_PK primary key (ID,SQE)
插入数据:
INSERT INTO TB_TEST_TWO (ID,NAME,AGE,SQE)
SELECT ID,NAME,AGE,(SELECT 1 FROM DUAL )
FROM TB_TEST_ONE
TB_TEST_TWO表插入后的信息