Use variables in filename with INTO OUTFILE (timestamped filename) SELECT *
FROM project
INTO OUTFILE 'C:\desktop\[timestamped filename like 01/05/2014.csv]';


Can anyone help me out?
Has said in this post, you can use:

SET @sql_text = 
   CONCAT (
       "SELECT * FROM `project ` into outfile 'C:\desktop\"
       , DATE_FORMAT( NOW(), '%d/%m/%Y')
       , ".csv'"
    );

PREPARE s1 FROM @sql_text;
EXECUTE s1;
DROP PREPARE s1;


Thanks Haim Evgi for the original answer.

Max.