Page 1 of 1

load data infile

Posted: Thu Aug 07, 2008 12:59 pm
by bouncer
hi there,

how can i set in the @datafield2 the value in $doc_date, so every time that i run the php script it set the date of server.

this is just an example of what i want to do ...

Code: Select all

 
$doc_date = date('Y-m-d');
 
LOAD DATA INFILE 'example.csv' REPLACE INTO TABLE `content`
                FIELDS TERMINATED BY ';'
                OPTIONALLY ENCLOSED BY ''
                LINES TERMINATED BY '\n'
                (`ref`, @datefield1, @datefield2)
                SET 
                `status_date` = STR_TO_DATE(@datefield1, '%d/%m/%Y'),
                `doc_date` = ????;
 
thanks in advance

Re: load data infile

Posted: Thu Aug 07, 2008 3:18 pm
by ghurtado
Could you do something like the following?

Code: Select all

$sql = " ... `status_date` = STR_TO_DATE($doc_date, '%d/%m/%Y') ... ";

Re: load data infile

Posted: Fri Aug 08, 2008 5:41 am
by bouncer
ghurtado wrote:Could you do something like the following?

Code: Select all

$sql = " ... `status_date` = STR_TO_DATE($doc_date, '%d/%m/%Y') ... ";
no that didn't work :(

regards

Re: load data infile

Posted: Fri Aug 08, 2008 6:28 am
by bouncer
i've tried this one and now it work just fine ... :D

Code: Select all

 
LOAD DATA INFILE 'example.csv' REPLACE INTO TABLE `content`
                FIELDS TERMINATED BY ';'
                OPTIONALLY ENCLOSED BY ''
                LINES TERMINATED BY '\n'
                (`ref`, @datefield1)
                SET 
                `status_date` = STR_TO_DATE(@datefield1, '%d/%m/%Y'),
                `doc_date` = CURRENT_TIMESTAMP;
 
regards