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=1 2.验证是否开启 mysql输入语句 show binary logs 3.查看日志： 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...

<?php namespace 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...