Go Back   Tech Support Forum > Design Forum > Web Serving and Management

User Tag List

mysql Multiple line insert

This is a discussion on mysql Multiple line insert within the Web Serving and Management forums, part of the Tech Support Forum category. 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


Closed Thread
 
Thread Tools Search this Thread
Old 07-17-2018, 12:52 PM   #1
Elite Commander
 
VividProfessional's Avatar
 
Join Date: Apr 2009
Location: Merseyside Uk
Posts: 1,406
OS: Windows 10

My System

Send a message via MSN to VividProfessional

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....
__________________
Boeing 787 Dreamliner Register
The worlds premier Dreamliner site
www.b787register.co.uk
VividProfessional is offline  
Sponsored Links
Advertisement
 
Old 07-31-2018, 03:30 AM   #2
Registered Member
 
Hostechsupport's Avatar
 
Join Date: Nov 2011
Location: India
Posts: 18
OS: win xp



The code seems correct but confirm it with your DB admin/Developer once.
Hostechsupport is offline  
Closed Thread

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Similar Threads
Thread Thread Starter Forum Replies Last Post
Possible Malware...computer running slow
Hello, I have a computer that is running very slow. Whenever it boot up to the desktop, it takes a while to load as well as popup boxes (which I believe was caused when the person who owns the computer clicked on the popups) show up. When I use Firefox, the homepage is Sweetpacks (which I...
hbkvcu Resolved HJT Threads 13 06-24-2014 06:19 PM
redirect virus
I'm having a problem where I randomly get redirected to this adobe spam site, as soon as a website redirects it automatically downloads something to my computer. I used to be able to cancel the download but now the files always save too fast for me to cancel. I also can't seem to get onto sites...
shelf12 Virus/Trojan/Spyware Help 34 03-26-2014 05:07 AM
RAM memory in BIOS
Hello When im trying to clock my RAM memory in BIOS its all gray. Any suggestions? "BIOS-Version and -date. American Megatrends Inc. 3.24, 2005-08-11" And installed RAM is only 512
Abfe Overclocking 6 01-27-2011 12:33 PM
Burning error in audio blank using Nero 6
I have a burning error in audio blank using Nero 6. Below is my log, What is the problem ? Windows XP 5.1 IA32 WinAspi: - ahead WinASPI: File 'C:\Program Files\Ahead\Nero\Wnaspi32.dll': Ver=2.0.1.74, size=164112 bytes, created 10/26/2004 5:35:34 PM
zhong Windows XP Support 12 01-13-2011 11:22 PM

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is on
Smilies are on
[IMG] code is on
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off


Post a Question


» Site Navigation
 > FAQ
  > 10.0.0.2
Powered by vBadvanced CMPS v3.2.3


All times are GMT -7. The time now is 09:42 PM.


Powered by vBulletin® Version 3.8.8
Copyright ©2000 - 2020, vBulletin Solutions, Inc.
vBulletin Security provided by vBSecurity v2.2.2 (Pro) - vBulletin Mods & Addons Copyright © 2020 DragonByte Technologies Ltd.
User Alert System provided by Advanced User Tagging v3.1.0 (Pro) - vBulletin Mods & Addons Copyright © 2020 DragonByte Technologies Ltd.
Copyright 2001 - 2018, Tech Support Forum

Windows 10 - Windows 7 - Windows XP - Windows Vista - Trojan Removal - Spyware Removal - Virus Removal - Networking - Security - Top Web Hosts