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
mysql根据select 结果insert
最新推荐文章于 2024-07-22 03:04:14 发布