测试数据库制作测试数据，制造假数据全部

Fanzongshen
已于 2023-12-12 16:22:09 修改
阅读量461
点赞数 9
文章标签：数据库制造 java
于 2023-12-08 14:49:21 首次发布
本文链接：https://blog.csdn.net/Fanzongshen/article/details/134878501
版权
制造假数据全部
		SET @start_id = 11;
        SET @start_time = '2023-06-16 15:30:00';
        SET @ne_name = '1';
        INSERT INTO
pm_gnodeb (id, time_key, `ne_name`,prb_assn_rate_ul,prb_assn_rate_dl,wireless_call_completion_rate,wireless_call_drop_rate)        
		VALUES   (@start_id, @start_time,@ne_name,(ROUND(RAND()*100, 1)),(ROUND(RAND()*100, 1)),(ROUND(RAND()*100, 1)),(ROUND(RAND()*100, 1))),
        (@start_id := @start_id + 1,@start_time := DATE_ADD(@start_time, INTERVAL 15 MINUTE),@ne_name,(ROUND(RAND()*100, 1)),(ROUND(RAND()*100, 1)),(ROUND(RAND()*100, 1)),(ROUND(RAND()*100, 1))),
        (@start_id := @start_id + 1,@start_time := DATE_ADD(@start_time, INTERVAL 15 MINUTE),@ne_name,(ROUND(RAND()*100, 1)),(ROUND(RAND()*100, 1)),(ROUND(RAND()*100, 1)),(ROUND(RAND()*100, 1))),
        (@start_id := @start_id + 1,@start_time := DATE_ADD(@start_time, INTERVAL 15 MINUTE),@ne_name,(ROUND(RAND()*100, 1)),(ROUND(RAND()*100, 1)),(ROUND(RAND()*100, 1)),(ROUND(RAND()*100, 1))),
        (@start_id := @start_id + 1,@start_time := DATE_ADD(@start_time, INTERVAL 15 MINUTE),@ne_name,(ROUND(RAND()*100, 1)),(ROUND(RAND()*100, 1)),(ROUND(RAND()*100, 1)),(ROUND(RAND()*100, 1))),
        (@start_id := @start_id + 1,@start_time := DATE_ADD(@start_time, INTERVAL 15 MINUTE),@ne_name,(ROUND(RAND()*100, 1)),(ROUND(RAND()*100, 1)),(ROUND(RAND()*100, 1)),(ROUND(RAND()*100, 1))),
        (@start_id := @start_id + 1,@start_time := DATE_ADD(@start_time, INTERVAL 15 MINUTE),@ne_name,(ROUND(RAND()*100, 1)),(ROUND(RAND()*100, 1)),(ROUND(RAND()*100, 1)),(ROUND(RAND()*100, 1))),
        (@start_id := @start_id + 1,@start_time := DATE_ADD(@start_time, INTERVAL 15 MINUTE),@ne_name,(ROUND(RAND()*100, 1)),(ROUND(RAND()*100, 1)),(ROUND(RAND()*100, 1)),(ROUND(RAND()*100, 1))),
        (@start_id := @start_id + 1,@start_time := DATE_ADD(@start_time, INTERVAL 15 MINUTE),@ne_name,(ROUND(RAND()*100, 1)),(ROUND(RAND()*100, 1)),(ROUND(RAND()*100, 1)),(ROUND(RAND()*100, 1))),
        (@start_id := @start_id + 1,@start_time := DATE_ADD(@start_time, INTERVAL 15 MINUTE),@ne_name,(ROUND(RAND()*100, 1)),(ROUND(RAND()*100, 1)),(ROUND(RAND()*100, 1)),(ROUND(RAND()*100, 1)));






		SET @start_id = 11;
        SET @start_time = '2023-06-16 15:30:00';
        SET @ne_name = '1';
        SET @s_nssai_id = '2';
        INSERT INTO
pm_upfns  (id, time_key, `ne_name`,n3_inc_oct_rate_ns,n3_og_oct_rate_ns,s_nssai_id)        
		VALUES   (@start_id, @start_time,@ne_name,(ROUND(RAND()*100, 1)),(ROUND(RAND()*100, 1)),@s_nssai_id),
        (@start_id := @start_id + 1,@start_time := DATE_ADD(@start_time, INTERVAL 15 MINUTE),@ne_name,(ROUND(RAND()*100, 1)),(ROUND(RAND()*100, 1)),@s_nssai_id),
        (@start_id := @start_id + 1,@start_time := DATE_ADD(@start_time, INTERVAL 15 MINUTE),@ne_name,(ROUND(RAND()*100, 1)),(ROUND(RAND()*100, 1)),@s_nssai_id),
        (@start_id := @start_id + 1,@start_time := DATE_ADD(@start_time, INTERVAL 15 MINUTE),@ne_name,(ROUND(RAND()*100, 1)),(ROUND(RAND()*100, 1)),@s_nssai_id),
        (@start_id := @start_id + 1,@start_time := DATE_ADD(@start_time, INTERVAL 15 MINUTE),@ne_name,(ROUND(RAND()*100, 1)),(ROUND(RAND()*100, 1)),@s_nssai_id),
        (@start_id := @start_id + 1,@start_time := DATE_ADD(@start_time, INTERVAL 15 MINUTE),@ne_name,(ROUND(RAND()*100, 1)),(ROUND(RAND()*100, 1)),@s_nssai_id),
        (@start_id := @start_id + 1,@start_time := DATE_ADD(@start_time, INTERVAL 15 MINUTE),@ne_name,(ROUND(RAND()*100, 1)),(ROUND(RAND()*100, 1)),@s_nssai_id),
        (@start_id := @start_id + 1,@start_time := DATE_ADD(@start_time, INTERVAL 15 MINUTE),@ne_name,(ROUND(RAND()*100, 1)),(ROUND(RAND()*100, 1)),@s_nssai_id),
        (@start_id := @start_id + 1,@start_time := DATE_ADD(@start_time, INTERVAL 15 MINUTE),@ne_name,(ROUND(RAND()*100, 1)),(ROUND(RAND()*100, 1)),@s_nssai_id),
        (@start_id := @start_id + 1,@start_time := DATE_ADD(@start_time, INTERVAL 15 MINUTE),@ne_name,(ROUND(RAND()*100, 1)),(ROUND(RAND()*100, 1)),@s_nssai_id);



		SET @start_id = 11;
        SET @start_time = '2023-06-16 15:30:00';
        SET @ne_name = '1';
        SET @s_nssai_id = '1';
        INSERT INTO
pm_smfns(id, time_key, `ne_name`,succ_create_pdu_rate_ns,s_nssai_id)        
		VALUES   (@start_id, @start_time,@ne_name,(ROUND(RAND()*100, 1)),@s_nssai_id),
        (@start_id := @start_id + 1,@start_time := DATE_ADD(@start_time, INTERVAL 15 MINUTE),@ne_name,(ROUND(RAND()*100, 1)),@s_nssai_id),
        (@start_id := @start_id + 1,@start_time := DATE_ADD(@start_time, INTERVAL 15 MINUTE),@ne_name,(ROUND(RAND()*100, 1)),@s_nssai_id),
        (@start_id := @start_id + 1,@start_time := DATE_ADD(@start_time, INTERVAL 15 MINUTE),@ne_name,(ROUND(RAND()*100, 1)),@s_nssai_id),
        (@start_id := @start_id + 1,@start_time := DATE_ADD(@start_time, INTERVAL 15 MINUTE),@ne_name,(ROUND(RAND()*100, 1)),@s_nssai_id),
        (@start_id := @start_id + 1,@start_time := DATE_ADD(@start_time, INTERVAL 15 MINUTE),@ne_name,(ROUND(RAND()*100, 1)),@s_nssai_id),
        (@start_id := @start_id + 1,@start_time := DATE_ADD(@start_time, INTERVAL 15 MINUTE),@ne_name,(ROUND(RAND()*100, 1)),@s_nssai_id),
        (@start_id := @start_id + 1,@start_time := DATE_ADD(@start_time, INTERVAL 15 MINUTE),@ne_name,(ROUND(RAND()*100, 1)),@s_nssai_id),
        (@start_id := @start_id + 1,@start_time := DATE_ADD(@start_time, INTERVAL 15 MINUTE),@ne_name,(ROUND(RAND()*100, 1)),@s_nssai_id),
        (@start_id := @start_id + 1,@start_time := DATE_ADD(@start_time, INTERVAL 15 MINUTE),@ne_name,(ROUND(RAND()*100, 1)),@s_nssai_id);



		SET @start_id = 10;
        SET @start_time = '2023-12-12 15:30:00'; -- 时间往后增加
        SET @ne_name = 'APP-HBWHUPFm017EHW-0004EHW011';
        SET @s_nssai_id = '2';
        INSERT INTO
pm_upf  (id, time_key, `ne_name`,upf_throughput_rate,mean_me_load,n6_inc_oct,n6_og_oct)        
		VALUES   (@start_id, @start_time,@ne_name,(ROUND(RAND()*100, 1)),(ROUND(RAND()*100, 1)),(ROUND(RAND()*10000, 3)),(ROUND(RAND()*10000, 3))),
        (@start_id := @start_id + 1,@start_time := DATE_ADD(@start_time, INTERVAL 15 MINUTE),@ne_name,(ROUND(RAND()*100, 1)),(ROUND(RAND()*100, 1)),(ROUND(RAND()*10000, 3)),(ROUND(RAND()*10000, 3))),
        (@start_id := @start_id + 1,@start_time := DATE_ADD(@start_time, INTERVAL 15 MINUTE),@ne_name,(ROUND(RAND()*100, 1)),(ROUND(RAND()*100, 1)),(ROUND(RAND()*10000, 3)),(ROUND(RAND()*10000, 3))),
        (@start_id := @start_id + 1,@start_time := DATE_ADD(@start_time, INTERVAL 15 MINUTE),@ne_name,(ROUND(RAND()*100, 1)),(ROUND(RAND()*100, 1)),(ROUND(RAND()*10000, 3)),(ROUND(RAND()*10000, 3))),
        (@start_id := @start_id + 1,@start_time := DATE_ADD(@start_time, INTERVAL 15 MINUTE),@ne_name,(ROUND(RAND()*100, 1)),(ROUND(RAND()*100, 1)),(ROUND(RAND()*10000, 3)),(ROUND(RAND()*10000, 3))),
        (@start_id := @start_id + 1,@start_time := DATE_ADD(@start_time, INTERVAL 15 MINUTE),@ne_name,(ROUND(RAND()*100, 1)),(ROUND(RAND()*100, 1)),(ROUND(RAND()*10000, 3)),(ROUND(RAND()*10000, 3))),
        (@start_id := @start_id + 1,@start_time := DATE_ADD(@start_time, INTERVAL 15 MINUTE),@ne_name,(ROUND(RAND()*100, 1)),(ROUND(RAND()*100, 1)),(ROUND(RAND()*10000, 3)),(ROUND(RAND()*10000, 3))),
        (@start_id := @start_id + 1,@start_time := DATE_ADD(@start_time, INTERVAL 15 MINUTE),@ne_name,(ROUND(RAND()*100, 1)),(ROUND(RAND()*100, 1)),(ROUND(RAND()*10000, 3)),(ROUND(RAND()*10000, 3))),
        (@start_id := @start_id + 1,@start_time := DATE_ADD(@start_time, INTERVAL 15 MINUTE),@ne_name,(ROUND(RAND()*100, 1)),(ROUND(RAND()*100, 1)),(ROUND(RAND()*10000, 3)),(ROUND(RAND()*10000, 3))),
        (@start_id := @start_id + 1,@start_time := DATE_ADD(@start_time, INTERVAL 15 MINUTE),@ne_name,(ROUND(RAND()*100, 1)),(ROUND(RAND()*100, 1)),(ROUND(RAND()*10000, 3)),(ROUND(RAND()*10000, 3)));


		 SET @start_id = 20;
         SET @start_time = '2023-11-17 15:30:00';
         SET @s_nssai_id = '128-448088';
         SET @ne_name = 'APP-HBWHUPFm017EHW-0004EHW011';
         INSERT INTO
pm_amfns (id, time_key, `s_nssai_id`,ne_name,reg_sub_ns,amf_reg_sub_ns,me_mean_me_load)        
		 VALUES(@start_id, @start_time,@s_nssai_id,@ne_name,(ROUND(RAND()*100, 1)),(ROUND(RAND()*100, 1)),(ROUND(RAND()*100, 1))),
         (@start_id := @start_id + 1,@start_time := DATE_ADD(@start_time, INTERVAL 15 MINUTE),@s_nssai_id,@ne_name,(ROUND(RAND()*100, 1)),(ROUND(RAND()*100, 1)),(ROUND(RAND()*100, 1))),
         (@start_id := @start_id + 1,@start_time := DATE_ADD(@start_time, INTERVAL 15 MINUTE),@s_nssai_id,@ne_name,(ROUND(RAND()*100, 1)),(ROUND(RAND()*100, 1)),(ROUND(RAND()*100, 1))),
         (@start_id := @start_id + 1,@start_time := DATE_ADD(@start_time, INTERVAL 15 MINUTE),@s_nssai_id,@ne_name,(ROUND(RAND()*100, 1)),(ROUND(RAND()*100, 1)),(ROUND(RAND()*100, 1))),
         (@start_id := @start_id + 1,@start_time := DATE_ADD(@start_time, INTERVAL 15 MINUTE),@s_nssai_id,@ne_name,(ROUND(RAND()*100, 1)),(ROUND(RAND()*100, 1)),(ROUND(RAND()*100, 1))),
         (@start_id := @start_id + 1,@start_time := DATE_ADD(@start_time, INTERVAL 15 MINUTE),@s_nssai_id,@ne_name,(ROUND(RAND()*100, 1)),(ROUND(RAND()*100, 1)),(ROUND(RAND()*100, 1))),
         (@start_id := @start_id + 1,@start_time := DATE_ADD(@start_time, INTERVAL 15 MINUTE),@s_nssai_id,@ne_name,(ROUND(RAND()*100, 1)),(ROUND(RAND()*100, 1)),(ROUND(RAND()*100, 1))),
         (@start_id := @start_id + 1,@start_time := DATE_ADD(@start_time, INTERVAL 15 MINUTE),@s_nssai_id,@ne_name,(ROUND(RAND()*100, 1)),(ROUND(RAND()*100, 1)),(ROUND(RAND()*100, 1))),
         (@start_id := @start_id + 1,@start_time := DATE_ADD(@start_time, INTERVAL 15 MINUTE),@s_nssai_id,@ne_name,(ROUND(RAND()*100, 1)),(ROUND(RAND()*100, 1)),(ROUND(RAND()*100, 1))),
         (@start_id := @start_id + 1,@start_time := DATE_ADD(@start_time, INTERVAL 15 MINUTE),@s_nssai_id,@ne_name,(ROUND(RAND()*100, 1)),(ROUND(RAND()*100, 1)),(ROUND(RAND()*100, 1)));