select insert
(?<=`) .* 通过正则替换表结构中的无用数据只留下字段名
Redis 定位IP地址的妙用
ZREVRANGEBYSCORE key max min [WITHSCORES] [LIMIT offset count]
laravel migration
通过migration来使每次部署变得简便
生成迁移文件： php artisan make:migration upgrade_to_v15
执行迁移： php artisan migrate
ES镜像开源用户认证
ES的用户验证插件无法免费试用，替换成免费的用户认证插件
不登录数据库执行mysql命令
mysql -u root -p'oldboy' -S /data1/3307/mysql.sock -e "show databases;"
docker the input device is not a TTY
报错：the input device is not a TTY
composer 移除依赖
composer remove beyondcode/laravel-query-detector --dev
mysql left join,right join,inner join 之间的区别
- left join,right join,inner join 之间的区别
2. distinct
3. group by
docker 容器启动失败，无权限 Permission denied
docker 容器启动报错
chown: changing ownership of '/data/db': Permission denied
chown: changing ownership of '/var/lib/mysql/': Permission denied
给docker给个特殊权限privileged: true
ES 重置密码
重置elasticsearch的超级管理员密码