qq_36028348的博客

导出数据在写出的时候会出现The MySQL server is running with the --secure-file-priv option so it cannot execute this statement的错误解决方法：出现这个错误是因为没有给数据库指定写出文件的路径或者写出的路径有问题。首先使用下面的命令 show variables like '%secure%'; 查看数据库的存储路径。如果查出的 secure_file_priv 是 null 的时候就证明在 my...

select order_id,order_sn from (select concat('@@',order_sn) as x ,order_sn,order_id from ecs_order_info where 1 = 1 having x like '@@%0002%') as t;

SELECT s.id,s.nick,s.userId,s.sid,s.session_key,s.retoke,s.shouquantime,s.refresh_token_timeout,s.timezone,t.endtimefrom taobao_session as s LEFT JOIN taobao_productrepost_set as ton t.memberId...