DSP

ibatis 嵌套insert select语句

2019-07-13 16:57发布

从dsp_subject 表查询若干记录,与其他记录‘somedesc’ 合并作为一条记录,插入到表dsp_hstry中
insert into dsp_hstry (sub_no,editer_no,edit_date,clasy,version,edit_des) (select no,cre_no,cre_date,clasy,version,'somedesc' from dsp_subject where no = 1); 注:语法是  insert into table1(a,b,c)(select a,b,"something" from table2)