I'm using MySQL 3.23.25 and phpMyAdmin 2.1.0 and I trying to put an exported CSV file from excel into a table using the Insert textfiles into table> function. The command appears to be completed successfully. I get
The content of your file has been inserted.
SQL-query:
LOAD DATA LOCAL INFILE '\\php2' INTO TABLE districts FIELDS TERMINATED BY ',' ENCLOSED BY '\"' ESCAPED BY '\\' LINES TERMINATED BY '\n'
However, no data appears in the table. Any advice?
Pete Jones
The content of your file has been inserted.
SQL-query:
LOAD DATA LOCAL INFILE '\\php2' INTO TABLE districts FIELDS TERMINATED BY ',' ENCLOSED BY '\"' ESCAPED BY '\\' LINES TERMINATED BY '\n'
However, no data appears in the table. Any advice?
Pete Jones