2021-07-17

首先在navicat中设计一个函数，选择过程，然后写入下面的代码
DECLARE id int;
DECLARE driverid int;
DECLARE baseid int;
set id=LAST_INSERT_ID()+1;
WHILE id<1700000 DO
set driverid=RAND()*67890;
set baseid=RAND()*1000;
INSERT INTO xxl.car_xx (id, driver_id, driver_phone, driver_name, order_no, created_time, car_group, service_type, numprize_base_id, order_amount, updated_time, order_praise, order_doubt, order_risk) VALUES (id, driverid, ‘15801050217’, ‘孔师傅’, CONCAT(‘P00000000’,id), ‘2017-10-28 20:21:54’, ‘34’, ‘1’, baseid, ‘11.00’, ‘2017-10-28 20:21:54’, ‘1’, ‘0’, ‘0’);

SET id=id+1;