[請益] phpmyadmin 中使用 outfile

作者: kiey (煉)   2014-08-04 16:28:39
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
但事實在是不知道該怎麼解決、不知是否有哪個地方打錯了?
作者: kiey (煉)   2014-08-04 16:54:00
作者: MOONRAKER (㊣牛鶴鰻毛人)   2014-08-04 23:40:00
replace三層…你有沒有聽過一個東東叫date_format()

Links booklink

Contact Us: admin [ a t ] ucptt.com