Provo a importare un file csv con phpmyadmin ma importa solo la prima riga, questa è la query che mi da come risultato:
LOAD DATA LOCAL INFILE '/tmp/phpKt3LZg' REPLACE INTO TABLE `pubblica`
FIELDS TERMINATED BY ';'
ENCLOSED BY '"'
ESCAPED BY '\\'
LINES TERMINATED BY '\r\n'# Righe interessate: 1
LOAD DATA LOCAL INFILE '/tmp/phpKt3LZg' REPLACE INTO TABLE `pubblica`
FIELDS TERMINATED BY ';'
ENCLOSED BY '"'
ESCAPED BY '\\'
LINES TERMINATED BY '\r\n'# Righe interessate: 1