flyfish2017-优快云博客

原创 Error: redis: Calling `cellar` in a bottle block is disabled

mac使用brew安装redis报错✘ xxx@XX-Pro  ~  brew install redis Error: redis: Calling `cellar` in a bottle block is disabled! Use `brew style --fix` on the formula to update the style or use `sha256` with a `cellar:` argument instead.Please report this issu..

2021-07-15 11:00:20 2448

转载 MySQL错误“Specified key was too long; max key length is 1000 bytes”的解决办法

经过查询才知道，是Mysql的字段设置的太长了，于是我把这两个字段的长度改了一下就好了。建立索引时，数据库计算key的长度是累加所有Index用到的字段的char长度后再按下面比例乘起来不能超过限定的key长度1000： latin1 = 1 byte = 1 character uft8 = 3 byte = 1 character gbk = 2 byte = 1 character 举例能...

2018-04-16 11:29:19 2832

原创 Mysql case when的使用，按天分组，统计crowd表，每天的完成人数

SELECT c.aid activity_id, DATE_FORMAT(c.createdate, '%Y%m%d') statistics_date,COUNT(c.id) total,SUM(CASEWHEN ((IFNULL(c.points, 0) + IFNULL(c.money, 0) + IFNULL(c.cashcoupon, 0)) / a.pri

2018-01-26 16:45:53 1211