Rename outfile with date in mysql

Question

How can i rename the filename with a concat function ? i want my filename with a date,, can anyone help me on this.

SET @OUTFILE = CONCAT( CONCAT('/xampp/htdocs/mysite/reports-', NOW()), '.csv');


SELECT * FROM `tbl_user` INTO OUTFILE  @OUTFILE FIELDS TERMINATED BY ','ENCLOSED BY '"' LINES TERMINATED BY '\n'

i always get this error : #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '@OUTFILE — avien, Jul 05 '12 at 05:50
actually im not so familiar in concatination in mysql, anyway i just want my filename to be dynamic, so everytime i run this query it gives me a unique filename with a date ;( — avien, Jul 05 '12 at 05:53

Haim Evgi · Accepted Answer · 2012-07-05T05:57:47.847

10

you can do something like:

SET @sql_text = 
   CONCAT (
       "SELECT * FROM `tbl_user` into outfile '/xampp/htdocs/mysite/reports-"
       , DATE_FORMAT( NOW(), '%Y%m%d')
       , ".csv'"
    );

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

edited Jul 05 '12 at 05:57

answered Jul 05 '12 at 05:52

Haim Evgi

123,187
45
217
223

if its help upvote and set as on V sign to set that is the correct answer – Haim Evgi Jul 05 '12 at 06:23

score 1 · Answer 2 · answered Jul 05 '12 at 05:49

1

You should use prepared statements. Build a query string, then execute it.

answered Jul 05 '12 at 05:49

Devart

119,203
23
166
186

Rename outfile with date in mysql

2 Answers2

Linked