hbuxzy的专栏

从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

insert into dsp_subrel (sub_no,son_no,version,rel_type) VALUES (#subNo#,#sonNo#,(select version from dsp_subject where no=#subNo#),#relType#)

insert语句中包含子查询问题Ibatis中的Insert语句，将values采用select代替 INSERT INTO FAQ ( topicID listID faqfloor ) SELE