It works!
Here is what I used:
LOAD DATA INFILE
'Batch.txt'
INTO TABLE
Batch
FIELDS TERMINATED BY
'{'
LINES TERMINATED BY
'\r\n';
And the result:
mysql> select * from batch where orderid=240414989;
+---+---++--+
| QAID | OrderID |
Does SQLyog log any errors for you? Are your lines terminated by \n or
\r\n? Have you tried performing this import with the LOAD DATA INFILE
command? There you could at least see if warnings or errors were
encountered.
Scott Hamm wrote:
I got my csv delimited using "{" as follows:
87547{2404149
