dynamic outfile name

[David Harris]

I am attempting to create text files using a batch file. This script below works to a point. Because the outfile can not be overwritten, I would like to name the text file with a unique name based upon the date and time. The @marcFile variable gets assigned but I can not pass it to outfile query.

------------------------------------
SELECT @sync:=concat(CURDATE(),CURTIME());

SELECT @marcFile:=CONCAT('c:/scripts/marcUpdate', @sync,'.txt');

SELECT * INTO OUTFILE @marcFile /* This works -> 'c:/scripts/marcUpdate.txt'*/
FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"'
LINES TERMINATED BY '\n'
FROM marcupdate;

------------------------------------
Any suggestions?

Best regards.