mysql - mysql - 在 SELECT * INTO OUTFILE(在文件名上)时使用变量(日期)

Question

下午好

我正在使用 INTO OUTFILE 创建一个包含 SELECT 信息的 CSV 文件。我需要使用变量来个性化 CSV 的名称。

例如，我想添加日期 NOW()。

这是想法(但行不通):

SET @outpath = "out/";
SET @outfile = (SELECT NOW());
SET @outextension = "_EMAIL_WithoutEmail.csv";
SET @outfull = CONCAT(@outpath,@outfile,@outextension);
SELECT *
    FROM `vn_db_tmp`
    INTO OUTFILE @outfull
    FIELDS TERMINATED BY ';'
    ENCLOSED BY '"'
    LINES TERMINATED BY '\n';

任何人都知道这是否可能？谢谢

Answer 1

一种选择是使用 13.5 Prepared SQL Statement Syntax .

例子:

...

SET @`outfull` := CONCAT('out/', NOW(), '_EMAIL_WithoutEmail.csv');    
SET @`qry` := CONCAT('SELECT * 
                        INTO OUTFILE \'', @`outfull`, '\' 
                        FIELDS TERMINATED BY \';\' 
                        ENCLOSED BY \'"\' 
                        LINES TERMINATED BY \'\n\' 
                      FROM `vn_db_tmp`');    
PREPARE `stmt` FROM @`qry`;
SET @`qry` := NULL;
EXECUTE `stmt`;
DEALLOCATE PREPARE `stmt`;
...