怎样向mysql数据库一张表里插入大量的模拟数据,假如已有一条数据。sql语句实现

发布网友 发布时间：2022-05-03 09:55

我来回答

共4个回答

懂视网 时间：2022-05-03 14:16

delimiter $$
#DROP PROCEDURE IF EXISTS data
CREATE PROCEDURE data(in i int)
BEGIN
WHILE i < 10000000 DO
INSERT INTO rs_a100000002_2020 (JLBH, VehicleID ,UniqueString ,RSStationCode,MonitorResult,Highemissions,Islocal,PassdateTime,VLPN,VLPNColor,FuelType,CarColor,CarType,VIN,
OwnerName,GAVType,VehicleType,HPZL,FactoryPlateModel,EDSPL,CO,CO2,`NO`,Opacity,RgB,NH3,NOx,HC,COXZ,CO2XZ,OpacityXZ,NH3XZ,NOxXZ,HCXZ,NOXZ,RgBXZ,
COJG,CO2JG,OpacityJG,NH3JG,NOxJG,HCJG,NOJG,RgBJG,HCCO2,NOCO2,COCO2,VSP,SPEED,Acceleration,Humidity,Atmosphere,WindSpeed,WindDirection,Temperature,Slope,VPSFJ,
SPEEDFJ,AccelerationFJ,HumidityFJ,AtmosphereFJ,WindSpeedFJ,WindDirectionFJ,TemperatureFJ,CountyCode,DDJD,DDWD,GJXXBH,YCXBH,Lane,Image1Name,Image1Path,Image2Name,Image2Path,
VideoName,VideoPath,JCDWRZH,JCRYXM,FilePath,ImportDatetime,SyncError,SyncErrorType,SyncFlag,Extent1,Extent2,RSType) VALUES(
i,
0,
‘‘,
‘A100000002‘,
‘1‘,
1,
1,
‘2020-05-15 19:12:12‘,
‘粤VQ4303‘,
‘01‘,
‘B‘,
‘‘,
‘小货车‘,
‘‘,‘‘,‘‘,‘‘,‘‘,‘‘,‘‘,
1.92,
7.13,
239.00,
13.00,
0,0.00,0.00,
158.00,
0.00,0.00,
30.00,
0.00,0.00,0.00,
1500.00,
0.00,0.00,‘‘,
‘1‘,
‘‘,‘‘,‘‘,
‘1‘,
‘‘,
22.16,
33.52,
0.27,
15.00,
52.00,
0.76,
79.10,
81.00,
1.00,
163.00,
17.50,
0.00,
‘‘,‘‘,‘‘,
‘{"UpperLimit":"85.00","LowLimit":"","JG":"1","remark":null}‘,
‘{"UpperLimit":"101.40","LowLimit":"70.00","JG":"1","remark":null}‘,
‘‘,‘‘,
‘{"UpperLimit":"45.00","LowLimit":"-20.00","JG":"1","remark":null}‘,
‘100000‘,
0,0,
‘200515000174‘,
‘‘,
2,
‘ycdatapic_20200302034851247_蓝粤VQ4303.jpg‘,
‘ycdatapic_20200302034851247_蓝粤VQ4303.jpg‘,
‘ycdatapic_20200302034851247_蓝粤VQ4303_vlpn.jpg‘,
‘ycdatapic_20200302034851247_蓝粤VQ4303_vlpn.jpg‘,
‘ycdata20200302034851248_粤VQ4303_2.mp4‘,
‘ycdata20200302034851248_粤VQ4303_2.mp4‘,
0,‘‘,‘‘,
‘2020-05-15 19:15:43‘,
‘‘,‘‘,1,‘‘,‘‘,1);
SET i=i+1;
END WHILE;
end
$$
set @id=0;
call data(@id);

mysql造模拟数据

标签：win   moni   exists   mis   begin   lag   HERE   creat   monitor   

热心网友 时间：2022-05-03 11:24

 使用数据库导入法：source d:/book.sql

热心网友 时间：2022-05-03 12:42

热心网友 时间：2022-05-03 14:17