Re: timestamp(14) fails to change on load data infile

2001-02-04 Thread Clownfish Internet Services - www.clown-fish.com
00 PM Subject: Re: timestamp(14) fails to change on load data infile > > When using a TIMESTAMP column with LOAD DATA INFILE, the TIMESTAMP must be > either set to NULL or an appropriate date within the import file or > specifically left out of the field list in the LOAD DATA INF

Re: timestamp(14) fails to change on load data infile

2001-02-04 Thread Pat Sherrill
When using a TIMESTAMP column with LOAD DATA INFILE, the TIMESTAMP must be either set to NULL or an appropriate date within the import file or specifically left out of the field list in the LOAD DATA INFILE statement as follows: LOAD DATA INFILE 'example.csv' replace into table example FIELDS