在mysql中重命名带有日期的outfile [英] Rename outfile with date in mysql
本文介绍了在mysql中重命名带有日期的outfile的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
如何使用concat函数重命名文件名?
i希望我的文件名有一个日期,任何人都可以帮助我这个。
SET @OUTFILE = CONCAT ('/ xampp / htdocs / mysite / reports-',NOW()),'.csv');
SELECT * FROM`tbl_user` INTO OUTFILE @OUTFILE FIELDS TERMINATED BY','ENCLOSED BY''LINES TERMINATED BY'\\\
'
解决方案
您可以执行某些操作 like :
SET @sql_text =
pre>
CONCAT $ bSELECT * 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;
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'
解决方案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;
这篇关于在mysql中重命名带有日期的outfile的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文