mysql和sqlserver中substring(order_date,int,int)的区别
select a.*,b.goods_name,b.goods_shichangjia*nums totalfee from (select sum(goods_quantity) nums,goods_id from t_orderitem where order_id in
(select order_id from t_order where substring(order_date,1,7)='2019-03' ) group by goods_id )
a left join t_goods b on a.goods_id = b.goods_id and b.goods_del='no'
同样的这句话,在sqlserver中可以正常显示
但是在mysql中
却查到是空,我很好奇,也很疑惑,难道哪里写错了&#