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 LOAD FILE
> statement for some ETL automation, but Im having difficulty passing the
> string into the LOAD statement:
>
> This will not work.
>
> SELECT @Today:=3DCURDATE();
>
> LOAD DATA LOCAL INFILE '/s3/data/[EMAIL PROTECTED]' INTO TABLE Data;
>
> Anyone ever try something similar? How can this be done?
>
> Thanks.
>
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NET http://www.ensita.net/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Gleb Paharenko
/ /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED]
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET
<___/ www.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
