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 | Errors | Comments |
+-------+-----------+--------+----------+
| 87547 | 240414989 | 0 | |
+-------+-----------+--------+----------+
1 row in set (0.56 sec)
Now I better get used with utilities themselves than to depend on
Gooey (GUI) stuff.
Thanks a bunches!
Scott
On Thu, 03 Mar 2005 09:46:10 -0600, Victor Pendleton
<vpendleton@stripped> wrote:
> 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.
