Please enable JavaScript.

Coggle requires JavaScript to display documents.

SQL查询 - Coggle Diagram

- - - - 管理中心、保存、执行
  - - - 6种支持类型
        
        Group By
        
        选择字段、语句同步
        
        Having
        
        条件判断、=、LIKE、NOT LIKE关键字判断
        
        单条件、多条件、AND OR组合判断
        
        Where
        
        值相等判断、LIKE、NOT LIKE关键字判断
        
        单条件、多条件、AND OR组合判断
        
        Order by
        
        选择字段、语句同步、选择升序/降序
        
        Joins
        
        条件选择
        
        选择连线状态同步
        
        连接类型选择
        
        多对多组合
        
        Selection
        
        表选择、表来源同步
        
        聚合函数Max,Min,Sum,Avg,Count
        
        字段自定义名获取、别名修改、同步
        
        字段选择、勾选同步、来源同步
        
        语法：AS
    - - DQL语句
        
        SELECT...FOR UPDATE
        
        SELECT...FROM...INNER | LEFT | RIGHT | CROSS | FULL | NATURE JOIN...ON...
        
        SELECT...FROM...ORDER BY...[ DESC | AES ]
        
        SELECT...FROM...GROUP BY...[ HAVING... ]
        
        SELECT...INTO...FROM...WHERE...
        
        SELECT...FROM...WHERE...LIKE '通配符 % _ [charlist] [^charlist] [!charlist] ]'
        
        CTE...etc.
        
        SELECT...FROM...WHERE...[ BETWEEN | IN ]...
        
        SELECT... [AS...] FROM... [AS...]