I want SQL query to update/insert data from table 1 to table 2 where the dates from first table will split into month, day, year. and I just want to update frame and month, day, year columns.

Computer Networking: A Top-Down Approach (7th Edition)
7th Edition
ISBN:9780133594140
Author:James Kurose, Keith Ross
Publisher:James Kurose, Keith Ross
Chapter1: Computer Networks And The Internet
Section: Chapter Questions
Problem R1RQ: What is the difference between a host and an end system? List several different types of end...
icon
Related questions
Question

I want SQL query to update/insert data from table 1 to table 2

where the dates from first table will split into month, day, year. and I just want to update frame and month, day, year columns.

A
В
C
D
E
F
H
J
K
id
path
prj2
rollt
filename project
roll
frame
flightcode scanres
dates
44955 T:\Aerials2 HAP02
233 НАРО2-23: НАРО2
233
33 НАРО2_233
09/26/85
45129 T:\Aerials2 HAP02
335 НАРО2-3! НАРО2
335
146 НАРО2_З35
06/03/86
06/08/86
06/09/86
45289 T:\Aerials2 HAP02
343 НАРО2-34: НАРО2
343
95 НАРО2_343
45465 T:\Aerials2 HAP02
349 НАРО2-34 НАРО2
349
185 НАРО2_З49
45561 T:\Aerials2 HAP02
351 НАРО2-35: НАРО2
351
86 НАРО2_351
06/09/86
45669 T:\Aerials2 HAPO2
353 НАРО2-35: НАРО2
353
1 НАРО2_353
06/07/86
45670 T:\Aerials2 HAP02
353 НАРО2-35: НАРО2
353
2 НАРО2_353
06/07/86
Transcribed Image Text:A В C D E F H J K id path prj2 rollt filename project roll frame flightcode scanres dates 44955 T:\Aerials2 HAP02 233 НАРО2-23: НАРО2 233 33 НАРО2_233 09/26/85 45129 T:\Aerials2 HAP02 335 НАРО2-3! НАРО2 335 146 НАРО2_З35 06/03/86 06/08/86 06/09/86 45289 T:\Aerials2 HAP02 343 НАРО2-34: НАРО2 343 95 НАРО2_343 45465 T:\Aerials2 HAP02 349 НАРО2-34 НАРО2 349 185 НАРО2_З49 45561 T:\Aerials2 HAP02 351 НАРО2-35: НАРО2 351 86 НАРО2_351 06/09/86 45669 T:\Aerials2 HAPO2 353 НАРО2-35: НАРО2 353 1 НАРО2_353 06/07/86 45670 T:\Aerials2 HAP02 353 НАРО2-35: НАРО2 353 2 НАРО2_353 06/07/86
id
[PK] integer
flightid
integer
flightname
project
roll
frame
flightline
month
day
year
smallint
text
text
text
text
text
smallint
smallint
7436152
53286 HAP02_389
НАРО2
389
060
[null]
8.
16
1986
7436153
53286 HAPO2_389
НАРО2
389
061
[null]
8.
16
1986
7436166
53286 HAP02_389
НАРО2
389
074
[null]
8
16
1986
7436187
53286 HAP02_389
НАРО2
389
096
[null]
8.
16
1986
7436189
53286 HAPO2_389
НАРО2
389
098
[null]
8.
16
1986
7436190
53286 HAPO2_389
НАРО2
389
099
[null]
8.
16
1986
Transcribed Image Text:id [PK] integer flightid integer flightname project roll frame flightline month day year smallint text text text text text smallint smallint 7436152 53286 HAP02_389 НАРО2 389 060 [null] 8. 16 1986 7436153 53286 HAPO2_389 НАРО2 389 061 [null] 8. 16 1986 7436166 53286 HAP02_389 НАРО2 389 074 [null] 8 16 1986 7436187 53286 HAP02_389 НАРО2 389 096 [null] 8. 16 1986 7436189 53286 HAPO2_389 НАРО2 389 098 [null] 8. 16 1986 7436190 53286 HAPO2_389 НАРО2 389 099 [null] 8. 16 1986
Expert Solution
steps

Step by step

Solved in 3 steps with 3 images

Blurred answer
Recommended textbooks for you
Computer Networking: A Top-Down Approach (7th Edi…
Computer Networking: A Top-Down Approach (7th Edi…
Computer Engineering
ISBN:
9780133594140
Author:
James Kurose, Keith Ross
Publisher:
PEARSON
Computer Organization and Design MIPS Edition, Fi…
Computer Organization and Design MIPS Edition, Fi…
Computer Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science
Network+ Guide to Networks (MindTap Course List)
Network+ Guide to Networks (MindTap Course List)
Computer Engineering
ISBN:
9781337569330
Author:
Jill West, Tamara Dean, Jean Andrews
Publisher:
Cengage Learning
Concepts of Database Management
Concepts of Database Management
Computer Engineering
ISBN:
9781337093422
Author:
Joy L. Starks, Philip J. Pratt, Mary Z. Last
Publisher:
Cengage Learning
Prelude to Programming
Prelude to Programming
Computer Engineering
ISBN:
9780133750423
Author:
VENIT, Stewart
Publisher:
Pearson Education
Sc Business Data Communications and Networking, T…
Sc Business Data Communications and Networking, T…
Computer Engineering
ISBN:
9781119368830
Author:
FITZGERALD
Publisher:
WILEY