Hello.
You could import data in the temporary table and then use a full
power of INSERT... SELECT statement. For example:
INSERT into t1 select col1,col2,curdate() from tmp_t1;
David Perron [EMAIL PROTECTED] wrote:
Im trying to get dynamically insert the current date into a
Im trying to get dynamically insert the current date into a LOAD FILE
statement for some ETL automation, but Im having difficulty passing the
string into the LOAD statement:
This will not work.
SELECT @Today:=CURDATE();
LOAD DATA LOCAL INFILE '/s3/data/[EMAIL PROTECTED]' INTO TABLE Data;