LOAD DATA LOCAL INFILE ddrop lib data cars csv REPLACE INTO TABLE cars

1
2
3
4
5
6
7
8
LOAD DATA LOCAL INFILE 'r:\\ddrop\\lib\\data\\cars.csv'
REPLACE
INTO TABLE cars
FIELDS
TERMINATED BY ','
LINES
TERMINATED BY '\n'
IGNORE 1 LINES