当前位置:Gxlcms > 数据库问题 > mysql order by排序查询速度问题

mysql order by排序查询速度问题

时间:2021-07-01 10:21:17 帮助过:6人阅读

* FROM `assets_message` LEFT JOIN purchase_message ON assets_message.purchase_id = purchase_message.purchase_id WHERE `purchase_type` = oassetsAND purchase_message.assets_type = 002 ORDER BY purchase_message.purchase_id,assets_id
SELECT * FROM `assets_message` LEFT JOIN purchase_message ON assets_message.purchase_id = purchase_message.purchase_id 
WHERE  `purchase_type` = oassets AND purchase_message.assets_type = 002
ORDER BY assets_message.purchase_id,assets_id

未完待续……

mysql order by排序查询速度问题

标签:sel   span   gpo   join   ase   排序   blog   mysq   post   

人气教程排行