1 2 3 4 5 6 7 8 9 10 11
| mysql -h 127.0.0.1 -u MOi -pMOI --database BDD -e "LOAD DATA LOCAL INFILE 'fichierData.csv'
IGNORE INTO TABLE maTable FIELDS TERMINATED BY ';'
LINES TERMINATED BY '\r\n'
SET
maTable.col1 = replace(col1, ',', '.'),
maTable.col2 = replace(col2, ',', '.'),
maTable.col3 = (select id from maTable4 where maTable4 .col1 = maTable.col3 limit 1),
maTable.col5 = (select IF(count(maTable2.col1) = 0, replace(maTable.col4, ' ', '_'), maTable2.col1) from maTable2 where maTable2.col2 = replace(maTable.col4, ' ', '_') order by maTable2.Id desc limit 1),
maTable.col6 = (select id from maTable3 where maTable3.col1 = maTable.col6 order by maTable3.id limit 1),
maTable.col7 = (select id from maTable5 where maTable5.col1 = maTable.col8),
maTable.col9 = (select id from maTable6 where maTable6.col1 = maTable.col8 limit 1)"; |
Partager