mysql
chineselogin
这个作者很懒,什么都没留下…
展开
-
mysql多表连接查询,统计求和,分组,时间条件,经典语句,ECstore
SELECT A.year, A.month, A.sale_member_id, B.name as sales_man, 0 as yd_sum, 0 as order_sum,A.member_id, “” as name, E.region_id as area, F.brand_name, GROUP_CONCAT(DISTINCT H.tag_name) as tag, C.cat_name,SUM(A.quantity) as quantity, SUM(A.money) as money原创 2021-01-20 10:22:47 · 601 阅读 · 2 评论 -
递归取所有子类/父类(子栏目/父栏目)
递归取所有子类/** * 取子栏目 * @param {Object} $category_id */ public function getSubCategories ($cid) { $ids_str = ''; if(is_array($cid)) { $ids_str = implode(',', $cid); } else { $ids_str = $cid; } $ids = $this->where('pid', 'IN', $原创 2021-03-04 21:48:50 · 239 阅读 · 5 评论