Importacao Marvel

converter xlsx para csv

libreoffice --headless --convert-to csv claim_rioclaro.xlsx --outdir .

importar csv para mysql

LOAD DATA INFILE "/var/lib/mysql-files/claim_rioclaro.csv"
INTO TABLE csv_claim_rio_claro
COLUMNS TERMINATED BY ','
OPTIONALLY ENCLOSED BY '"'
ESCAPED BY '"'
LINES TERMINATED BY '\n'
IGNORE 1 LINES;

LOAD DATA INFILE "/var/lib/mysql-files/claim_manaus.csv"
INTO TABLE csv_claim_manaus
COLUMNS TERMINATED BY ','
OPTIONALLY ENCLOSED BY '"'
ESCAPED BY '"'
LINES TERMINATED BY '\n'
IGNORE 1 LINES;

LOAD DATA INFILE "/var/lib/mysql-files/claim_joinville_novo.csv"
INTO TABLE csv_claim_joinville
COLUMNS TERMINATED BY ';'
OPTIONALLY ENCLOSED BY '"'
ESCAPED BY '"'
LINES TERMINATED BY '\n'
IGNORE 1 LINES;