Re: dynamic outfile name

[David Harris]

Sorry, the prepare statement is still returning a syntax error. I've tried using double quotes, escape slashes and even no quotes without luck. What am I missing?

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

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


PREPARE stmt_name FROM concat("SELECT * INTO OUTFILE", @marcFile, "FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' LINES TERMINATED BY '\n' FROM marcupdate");

EXECUTE stmt_name;

DEALLOCATE PREPARE stmt_name;
--------------------------