mysql concat错误

Question

请问一下
我想设置导出前一天的表格，我的代码如下：

select @lastday := date_sub(curdate(),interval 1 day);
SET @datanewname = '_m2_raw_Data';
SELECT @datalasttablename:=concat(@lastday,@datanewname);
SELECT @query:=CONCAT('select * from ',@`datalasttablename`)
INTO OUTFILE 'C:\\Db\\M2data.csv'
FIELDS TERMINATED BY ','
OPTIONALLY ENCLOSED BY '"'
LINES TERMINATED BY '\n';

但是尝试运行后，文件夹的csv文件只有一行 select * from '2017-11-12_m2_raw_data'
我觉得它就导出了一句order。 我想问一下如何把后面的内容都添加在concat里面，里面有',' '"' 'n'。
谢谢

Answer 1

加转义符就可以了啊
CONCAT("select * from ",@datalasttablename," INTO OUTFILE 'C:\Db\M2data.csv' FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' LINES TERMINATED BY '\n';")