美文网首页
mysql using issue

mysql using issue

作者: laravel | 来源:发表于2017-12-20 09:55 被阅读7次

sql1 数据量14

select t1.orderId,count(1) from xishiqu.xsq_order t1
join xishiqu.xsq_event t2 on t1.eventId=t2.eventId
where date(t1.pubTime)='2017-12-18'
group by t1.orderId
order by 2 desc

sql2 数据量1138806

select t1.orderId,count(1) from xishiqu.xsq_order t1
join xishiqu.xsq_event t2 on using(eventId)
where date(t1.pubTime)='2017-12-18'
group by t1.orderId
order by 2 desc

我一定是用了假的mysql

相关文章

网友评论

      本文标题:mysql using issue

      本文链接:https://www.haomeiwen.com/subject/tggwwxtx.html