msyql 批量导入 同时生成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

	)

三、遇到的报错

四、参考博客