具体sql如下:
将查询的结果插入到表life_di_detail中
insert INTO life_di_detail (id ,qianid,xianji ,title , jieqian , shiyi , jieyue,shiyue ,gushi) SELECT 5, qid ,jie , qy ,xiaie , shiyi , guren ,shiyue ,qianming from sm_chouqian where tid=396
相关标签: