From: Jean-Michel OLTRA (jm.oltraespinasse.net)
Date: Thu Apr 29 2004 - 07:23:40 CDT

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

Le jeudi 29 avril 2004, Heiko Giesselmann a écrit...

        bonjour,

> The data file t1.dat contains the following entries:
> 2004-04-26 07:00:00,1.0,test1
> 2004-04-26 07:00:00,2.0,test2
> 2004-04-26 07:00:00,3.0,test3

> Error during execution
> -->-25319
> Missing data for specified column C2.

I think fields should be enclosed in double quotes (with this loading
syntax using defaults delimiter/separator):

"2004-04-26 07:00:00","1.0","test1"
and so on

--
jm

--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]