摘要:
NOT EXISTS SELECT a.*FROM t_user aWHERE a.id_card LIKE '%3203821995100%'AND NOT EXISTS ( SELECT id FROM tr_user_product_doctor tupd WHERE a.id = tupd. 阅读全文
posted @ 2018-01-04 16:33
今天又懒得加班
阅读(577)
评论(0)
推荐(0)
摘要:
INSERT INTO tr_user_product_doctor ( user_id, product_id, doctor_id) SELECT user_id, product_id, 'doctorId'FROM tr_product_user trpuWHERE trpu.user_id 阅读全文
posted @ 2018-01-04 15:12
今天又懒得加班
阅读(151)
评论(0)
推荐(0)