INSERT INTO `water_meter_info` (
`bus_business_id`,
`bus_project_id`,
`meter_sort`,
`memter_number`,
`meter_name`,
`meter_ratio`,
`meter_address`,
`recycle_flag`,
meter_status,
`meter_brand_model`,
`meter_manufacturer`,
`meter_price`,
`meter_buy_date`,
`meter_begin_date`,
`replace_old_meter_flag`,
`old_meter_id`,
`meter_initial_degree`,
`attachment_no`,
`memter_qr_code_id`,
`meter_last_degree`,
`meter_latest_reading_time`,
`meter_latest_reading_record_id`,
`check_status`,
`meter_remark`,
`create_time`,
`create_user_id`,
`delete_flag`,
`cancel_user_id`,
`cancel_time`
)
SELECT
`bus_business_id`,
`bus_project_id`,
`meter_sort`+(SELECT CONCAT('1',CEILING(RAND()*900000000+100000000))),
`memter_number`+(SELECT CONCAT('1',CEILING(RAND()*900000000+100000000))),
`meter_name`,
`meter_ratio`,
`meter_address`,
`recycle_flag`,
1,
`meter_brand_model`,
`meter_manufacturer`,
`meter_price`,
`meter_buy_date`,
`meter_begin_date`,
0,
'',
`meter_initial_degree`,
'',
'',
`meter_last_degree`,
`meter_latest_reading_time`,
'',
0,
`meter_remark`,
`create_time`,
`create_user_id`,
`delete_flag`,
`cancel_user_id`,
`cancel_time`
from water_meter_info
数据库插入批量数据
最新推荐文章于 2024-07-09 11:09:43 发布