Mysql常用语句(持续更新)

个人拙见，不保证流程正确性,如有错误，请评论指正，谢谢！

分组排序

SELECT
	m1.ID,
	m1.RESOURCE_TYPE,
	m1.SORT
FROM
	resource_manage m1
LEFT JOIN resource_manage m2 ON m1.RESOURCE_TYPE = m2.RESOURCE_TYPE
GROUP BY
	m1.ID
ORDER BY
	m1.RESOURCE_TYPE,
	m1.SORT
流程:
1. 表(m1)左关联自身(m2) 关联条件为 m1.RESOURCE_TYPE = m2.RESOURCE_TYPE (相当于)
2.