标签：code curr pay 导入 msyql user end null ID
一、背景
二、实现
点击查看代码
INSERT into rev_water_user_pay
(
SELECT
(SELECT CONCAT(
FLOOR(RAND() * 99999),
LPAD(FLOOR(RAND() * 999999999), 12, '0')
) AS random_string) AS id,
null as user_code,
"1" as user_type,
u.username as user_name,
u.meter_code,
"5" as pay_type,
null as order_number,
u.last_end_code as last_end_code,
u.curr_end_code as curr_end_code,
u.total_usage as total_usage,
u.unit_price as unit_price,
u.pay_need,
u.pay_curr,
u.pay_pre + pay_pre_1 as pay_pre,
null as s_pay_sum,
u.last_arrears,
u.curr_arrears,
u.balance,
null as updatetime,
u.billtime,
null as paytime,
"0" as data_status,
null as data_version,
null as opt_userid,
null as create_by,
null as update_by,
(SELECT NOW()) as create_time,
null as update_time
FROM
rev_water_user_pay_1 u
)
三、遇到的报错
四、参考博客
标签：code,
curr,
pay,
导入,
msyql,
user,
end,
null,
ID
From： https://www.cnblogs.com/lcaiqin/p/17774837.html