[请益] 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