常见的一些mysql多表操作收集（备份）

原帖地址：https://blog.csdn.net/qq_37248648/article/details/78468291

多表操作框架

SELECT
    A.ID,
    A.NUMBER,
    A.PRICE,
    A.ORDER_TIME,
    B.USER_ID,
    B.STARTIME,
    B.STOPTIME,
    C.CHANNEL_PAY,
    D.COMPANY
FROM
    D表 D
LEFT JOIN A表 A ON A.COMPANY_ID = D.UID
LEFT JOIN B表 B ON B.COMPANY_ID = D.UID
LEFT JOIN C表 C ON C.COMPANY_ID = D.UID
有条件的再加行：
WHERE ..........
排序(如A表的ID由大到小排):
ORDER BY A.ID DESC
--------------------- 
作者：请叫我法斗先生 
来源：CSDN 
原文：https://blog.csdn.net/qq_37248648/article/details/78468291 
版权声明：本文为博主原创文章，转载请附上博文链接！

按照模板写的实例代码

SELECT user.id, user.key, class.value, config.value,log.value,control.value
FROM 云用户表 AS user
LEFT  JOIN 云类别表 AS class ON user.key = class.key
LEFT  JOIN 云配置表 AS config ON user.key = config.key
LEFT  JOIN 云日志表 AS log ON user.key = log.key
LEFT  JOIN 云控制表 AS control ON user.key = control.key
where class.value='35438264'
order by log.key,user.id
LIMIT 0 , 30

多表删除

原帖：https://www.cnblogs.com/princessd8251/articles/5551651.html

多表修改

原帖：https://blog.csdn.net/s20082043/article/details/43453391

231