Question: LOAD DATA INFILE ' / home / codio / workspace / FleetMaintenanceRecords . csv ' - > INTO TABLE PartsMaintenance - > FIELDS TERMINATED BY

LOAD DATA INFILE '/home/codio/workspace/FleetMaintenanceRecords.csv'
-> INTO TABLE PartsMaintenance
-> FIELDS TERMINATED BY ','
-> ENCLOSED BY '"'
-> LINES TERMINATED BY '\r
'
-> IGNORE 1 ROWS;
Query OK,0 rows affected (0.00 sec)
Records: 0 Deleted: 0 Skipped: 0 Warnings: 0

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!