Linux
0
Вклад в тег
LOAD DATA INFILE '/status2_50m.csv'
INTO TABLE compression_test.accounts_status50m
FIELDS TERMINATED BY ';' ESCAPED BY '\\'
LINES STARTING BY '' TERMINATED BY '\n'
IGNORE 1 LINES
(@col1,@col2,@col3) set account_id=@col1,service_id=@col2,status=@col3;
(@col1,@col2,@col3) set account_id=@col1,service_id=@col2,status=@col3;