[大数据]MYSQL批量添加数据-函数

begin
    declare i int;
    set i=100;
    while i<200 do
    INSERT INTO `t_camera` (`camera_id`, `camera_type_id`, `camera_name`, `mac_addr`, `ip_addr`, `user_id`, `site_id`, `rtsp_url`, `status`, `vendor_id`, `camera_model_id`, `dev_id`, `position`, `content`, `vendor_name`, `camera_mode`, `sys_name`, `direction_id`, `sc_type_id`) VALUES
    (i, 3,concat('v',i), NULL, NULL, 1, 1, concat('rtsp://192.168.2.5/v',i), 'online', NULL, NULL, concat('v',i), concat('v',i), NULL, concat('v',i), concat('v',i), 'zjc', 1, 1);
    
    INSERT INTO `t_stream` (`stream_id`, `camera_id`, `ithw_id`, `stream_name`, `rtsp_url`, `start_time`, `end_time`, `status`) VALUES
	  (i, i, 6, concat('v',i), concat('rtsp://192.168.2.5/v',i),  '2022-01-27 17:05:01', '2099-01-27 17:05:02', 'stop');

    INSERT INTO `t_system_stream` (`system_stream_id`, `camera_id`, `ithw_id`, `rtsp_url`, `start_time`, `end_time`, `status`) VALUES
	  (i, i, 6, concat('rtsp://192.168.2.5/v',i), '2021-06-26 10:00:00', '2999-12-31 23:59:59', 'on');
   
   set i=i+1;
   end while;
end