mysql根据select 结果insert

最新推荐文章于 2024-07-22 03:04:14 发布

「已注销」

最新推荐文章于 2024-07-22 03:04:14 发布

阅读量2.2w

点赞数

本文链接：https://blog.csdn.net/viplisong/article/details/90178713

版权

INSERT INTO peiyou.`py_payment_log` (
  order_code,
  pay_code,
  user_id,
  channel,
  payment_code,
  payment_name,
  need_pay,
  pay_return_value,
  pay_notify_value,
  pay_status,
  MID,
  tid,
  payTime,
  seqId,
  create_time
)
SELECT
  order_sn order_code,
  pay_sn pay_code,
  member_id user_id,
  'cms',
 paycode payment_code,
 paycode payment_name,
 money need_pay,
 pay_return_value pay_return_value,
 pay_return_value pay_notify_value,
 STATUS pay_status,
  '' MID,
  '' tid,
  FROM_UNIXTIME(end_time)  payTime,
  ''seqId,
  FROM_UNIXTIME(begin_time) 
FROM
  education.gt_payment_log
WHERE order_sn IN
  (SELECT
    order_code
  FROM
   peiyou.py_account_check_result) AND STATUS=1