Tech Support Forum banner
Status
Not open for further replies.
1 - 2 of 2 Posts

· Elite Commander
Veeam, HyperV, Vcentre, Server (2008 - 2022)
Joined
·
1,441 Posts
Discussion Starter · #1 ·
I have the following code, only showing two lines
Code:
insert into spotting (id, date, uname, location, type, registration,make,model,engine,operator,eng_make,eng_model,eng_vari,eng_num,role,config,icao,modes,ff,secal,unotes,anotes,viewable)  
SELECT id, lastSeen, 'David', 'KirKby Radar', 'Radar', 'G-AAAA','','','','','','','','','','','','44083b','','','','V1.121','Yes' FROM `adsb_logs` WHERE icao = '44083b';
insert into spotting (id, date, uname, location, type, registration,make,model,engine,operator,eng_make,eng_model,eng_vari,eng_num,role,config,icao,modes,ff,secal,unotes,anotes,viewable)  
SELECT id, lastSeen, 'David', 'KirKby Radar', 'Radar', 'G-AAAB','','','','','','','','','','','','44083b','','','','V1.121','Yes' FROM `adsb_logs` WHERE icao = '44083c';
i have around 170,000 lines I need to run daily. do I really have to run
Code:
insert into spotting (id, date, uname, location, type, registration,make,model,engine,operator,eng_make,eng_model,eng_vari,eng_num,role,config,icao,modes,ff,secal,unotes,anotes,viewable)
prior to each line, thereby making the script 340,000 rows....
 
1 - 2 of 2 Posts
Status
Not open for further replies.
Top