$sql = "LOAD DATA INFILE 'E:\EasyPHP-12.1\www\logintest\ASSETS.txt' INTO TABLE stock_names
FIELDS TERMINATED BY '^' LINES TERMINATED BY '^^\r\n'";
However, nothing is being inserted and no error messages are appearing. Does anybody know what's going wrong?
Perhaps I'm doing it all wrong, in which case can somebody suggest an appropriate alternative?
Try using a tab delimited file instead.
I update 64,000 rows every week using a tab delimited file and it works every time.
Inventing your on type of csv file is never worth the effort when there are tried and tested methods.