mysql边查询边插入

----------------没有where条件的----------------------
 insert into question (id,question,right_answer,analysis,score,`level`,type,
   create_time, update_time,is_delete
   ) select (SELECT REPLACE(uuid(), '-', '')) as id,jq.question,jq.answer,jq.analysis,jq.score,jq.`level`,2,(now()) as create_time,(now()) as update_time,0 as is_delete from judge_question as jq
----------------有where条件的--------------------------
insert into patient_adress_order (id, `name`,order_id,
      phone, patient_id, district,
      privovince, city, adress,create_time, update_time,is_delete

      ) select (SELECT REPLACE(uuid(), '-', '')) as id,pa.name,#{order_id,jdbcType=VARCHAR} as order_id,pa.phone,pa.patient_id,pa.district,pa.privovince,pa.city,pa.adress as adress,(now()) as create_time,(now()) as update_time,"0" as is_delete from patient_adress as pa

       where pa.id=#{paid,jdbcType=VARCHAR}