qq_41900118的博客

select GROUP_CONCAT('goods_name') as goods_name from goods; 获取到的商品名称用逗号隔开 例如： 苹果,梨,橘子select count('goods_name') as count from goods; 统计商品的个数select sum('goods_number') as sum from order;统计订单中商品的数量和...

1时间戳用这种$where['order_time'] = ['between', strtotime($input['start_time']).",".strtotime($input['end_time'])];日期格式用这种会报错SQLSTATE[42S22]: Column not found: 1054 Unknown column 'delivery_time' in 'wher...

SQLSTATE[42000]: Syntax error or access violation: 1064 memory exhausted near '13000005332,'158a46e11d40271f1ddc25e415f72c8b',53,'2',0,0,2,1,1577351250 UNION A' at line 1我在测试批量上传，传到5332条的时候就失败了！inse...