[請益] phpmyadmin 中使用 outfile

[kiey (煉)]

SQL 如下：

SET @logpath = ( SELECT CONCAT( 'tmp/52_setUser_',
replace(replace(replace(NOW(),'-',''),':',''),' ','') ,'.log' ) );

SELECT  *
FROM pp
into outfile @logpath



一直出現#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
'@logpath' at line 3


但事實在是不知道該怎麼解決、不知是否有哪個地方打錯了？

--
※ 發信站: 批踢踢實業坊(ptt.cc), 來自: 1.173.59.58
※ 文章網址: http://www.ptt.cc/bbs/PHP/M.1407140923.A.F5E.html
→ kiey:http://www.111cn.net/database/mysql/45631.htm
→ kiey:已解決！
→ MOONRAKER:replace三層…你有沒有聽過一個東東叫date_format()