UC知道mysql语句看不懂~谁帮我解释下？
来源：百度知道 编辑：UC知道 时间：2024/06/20 17:09:59
SELECT m.*, u.name AS editor, g.name AS groupname, c.publish_up, c.publish_down, com.name AS com_name
FROM jos_menu AS m
LEFT JOIN jos_users AS u ON u.id = m.checked_out
LEFT JOIN jos_groups AS g ON g.id = m.access
LEFT JOIN jos_content AS c ON c.id = m.componentid AND m.type = "content_typed"
LEFT JOIN jos_components AS com ON com.id = m.componentid AND m.type = "component"
WHERE m.menutype = 'mainmenu' AND m.published != -2
ORDER BY m.ordering ASC, m.parent, m.ordering
好长啊~看了半天看不明白~哪位大哥解释下~详细点~最好分段说明~
好的话我再追加50分啊~拜谢！
FROM jos_menu AS m
LEFT JOIN jos_users AS u ON u.id = m.checked_out
LEFT JOIN jos_groups AS g ON g.id = m.access
LEFT JOIN jos_content AS c ON c.id = m.componentid AND m.type = "content_typed"
LEFT JOIN jos_components AS com ON com.id = m.componentid AND m.type = "component"
WHERE m.menutype = 'mainmenu' AND m.published != -2
ORDER BY m.ordering ASC, m.parent, m.ordering
好长啊~看了半天看不明白~哪位大哥解释下~详细点~最好分段说明~
好的话我再追加50分啊~拜谢！
SELECT m.*, u.name AS editor, g.name AS groupname, c.publish_up, c.publish_down, com.name AS com_name
;选择所需要的属性，
FROM jos_menu AS m ；从 jos_menu表中
LEFT JOIN jos_users AS u ON u.id = m.checked_out
；jos_menu表和jos_users 左连接
LEFT JOIN jos_groups AS g ON g.id = m.access
jos_users 和jos_groups 左连接
LEFT JOIN jos_content AS c ON c.id = m.componentid AND m.type = "content_typed"
LEFT JOIN jos_components AS com ON com.id = m.componentid AND m.type = "component"
WHERE m.menutype = 'mainmenu' AND m.published != -2 ；条件
ORDER BY m.ordering ASC, m.parent, m.ordering
以ordering分组并升序排列，如果有相同的属性则按parent排列 以此类推
明白吗？？？