twscsdn的博客

mysql 取分数排名 0.5-0.8 数据SELECT * FROM (SELECT * FROM (SELECT @rownum := @rownum + 1 rownum, ## 获取行号 u2.* FROM ( SELECT @rownum := 0 ) t1, ( SELECT * FROM yide_user2 u ORDER BY u.total_scores + 0 DESC ) u2 ) a ) a WHERE ( ## 取行号后0.5 a.r

SELECT p.*,t3.percent,t3.completed_num FROM yide_work7 p LEFT JOIN ( SELECT p.*, round( max( l.completed_num + 0 ) / p.goal * 100, 2 ) AS percent, l.completed_num FROM yide_work7 p LEFT JOIN yide_work7_log l ON p.id = l.work3

1.修改配置文件修改my.ini在最后添加配置#添加这一行就ok log-bin=mysql-bin#选择row模式binlog-format=ROW#配置mysql replaction需要定义，不能和canal的slaveId重复server_id=12.验证是否开启mysql输入语句show binary logs3.查看日志：show binlog events in 'mysql-bin.000001';...

https://www.toutiao.com/i6762318923653186061/?tt_from=weixin&utm_campaign=client_share&wxshare_count=1&timestamp=1583735113&app=news_article&utm_source=weixin&utm_medium=toutia...

<?phpnamespace app\admin\controller;use PHPExcel\PHPExcel_IOFactory;use think\Db;//use think\Loader;use think\Request;use think\Session;//use vendor\PHPExcel\IOFactory;class Phone exten...