比如:
create table BSS_UserContractModifyInfo
(
userContract_Name Timestamp,
contract_code Varchar2(50),
iniFee float
);
insert into BSS_UserContractModifyInfo(contract_code,iniFee) values ('市_KJ',0.0);
insert into BSS_UserContractModifyInfo(contract_code) values ('市-SW-201405-036');
insert into BSS_UserContractModifyInfo(contract_code,iniFee) values ('市_KJ-2015',2000);
然后怎么往表中第二行数据插入 iniFee
å¨insert intoè¯å¥ä¸æ·»å æå®çå段å³å¯ã
å¦ä»¥ä¸æ°æ®ï¼
test1表ä¸ï¼
test表ä¸test1表ç»æç¸åï¼ä½ç®åæ æ°æ®ï¼ç°å¨è¦æ±å°test1ä¸çidæå ¥å°testä¸ï¼ä¸å¤çnameå段ï¼å¯ç¨å¦ä¸è¯å¥ï¼
insert into test(id) select id from test1;æ§è¡åï¼test表ä¸æ°æ®å¦ä¸ï¼