11 2022 档案

tp compser更新后找不到控制器
摘要：打开 /项目/vendor/services.php文件 <?php // This file is automatically generated at:2020-06-04 15:08:07 declare (strict_types = 1); return array ( 0 => 'thi 阅读全文
posted @ 2022-11-21 17:08 Abner3721 阅读(27) 评论(0) 推荐(0) 编辑
mysql 查询出来ID作为条件更新
摘要：update v5_user set is_invite = 1 where id in ( select temp.to_uid from ( select to_uid from v5_invite_user where 1 ) temp ) 阅读全文
posted @ 2022-11-17 09:41 Abner3721 阅读(203) 评论(0) 推荐(0) 编辑
mysql删除重复的数据，兵留最小一条数据
摘要：DELETE FROM v5_shops WHERE id NOT IN ( SELECT t.id FROM ( SELECT MIN(id) AS id FROM v5_shops GROUP BY `shop_no` ) t ) 阅读全文
posted @ 2022-11-15 19:37 Abner3721 阅读(18) 评论(0) 推荐(0) 编辑
mysql5.7以上不能分组
摘要：sql_mode='STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION' 阅读全文
posted @ 2022-11-14 20:23 Abner3721 阅读(14) 评论(0) 推荐(0) 编辑