begin
START TRANSACTION;
insert into tb_purchaseservice_history(purchaseId,
patientId,doctorId,state,consumePoint,transfertime)
select purchaseId,patientid,doctorid,'5',
consumePoint,createtime from tb_purchaseservice_relation
where state=1 and createtime <date_sub(curdate(),interval 2 day);
procedure 存储过程 将查出的结果映射到另一个表中
最新推荐文章于 2019-07-15 13:03:00 发布