<?php
$sql = "
LOAD DATA INFILE 'huge.csv'
INTO TABLE country
FIELDS TERMINATED BY ' , '
ENCLOSED BY ' \" '
LINES TERMINATED BY ' \n '
IGNORE 1 ROWS
";
echo $sql;
- Output for 5.6.0 - 5.6.23, 7.0.0 - 7.0.20, 7.1.0 - 7.1.20, 7.2.6 - 7.2.33, 7.3.16 - 7.3.33, 7.4.0 - 7.4.33, 8.0.0 - 8.0.30, 8.1.0 - 8.1.31, 8.2.0 - 8.2.27, 8.3.0 - 8.3.15, 8.4.1 - 8.4.2
- LOAD DATA INFILE 'huge.csv'
INTO TABLE country
FIELDS TERMINATED BY ' , '
ENCLOSED BY ' " '
LINES TERMINATED BY '
'
IGNORE 1 ROWS
preferences:
51.37 ms | 408 KiB | 5 Q