Please enable JavaScript.

Coggle requires JavaScript to display documents.

Banco de Dados (Type (Int, Float, Char(), Varchar(), Bool, Text, Serial,…

- - - - Create Table tab
        
        ( col type, primary key ( col ) )
        
        ( col type, foreign key ( col ) references tab ( col ) )
        
        As Select * From tab
    - - Alter Table tab
        
        Add col type
        
        Drop col
        
        Rename Column nome To novoNome
        
        Alter Column col type novoTipo
        
        Add Primary Key ( col )
        
        Add Foreign Key ( col ) References tab ( col )
        
        Alter Column col Set Not Null
        
        Alter Column col Drop Not Null
    - - Drop Table If Exists tab
      - Drop Table tab
  - - - Insert Into tab ( cols )
        
        Select cols From tab
        
        Values ( v1, ...,v3), ( v1, ...,v3)
    - - Update tab
        
        Set col = valor
        
        Where col <condição>
    - - Delete From tab
        
        Where col <condição>
  - - - Ordenação
        
        Order By
        
        Asc | Desc
      - Agrupamento
        
        Group By
        
        Having
        
        Funções
        
        COUNT()
        
        AVG()
        
        SUM()
        
        MAX()
        
        MIN()
        
        STDDEV()
      - Função Arimética
        
        [ + - / * % ]
      - Filtros
        
        Where
        
        In
        
        ( select distinct * from tab)
        
        Lógicos
        
        >= <= < > <>
        
        Like | Ilike
        
        ' _ % '
        
        Is Null | Is Not Null
      - Junção
        
        Join
        
        Right | Left Outer
        
        Inner
        
        On (tab1.col = tab2.col)
      - Paginação
        
        Limit nº Offset nº
        
        Limit: Apresentada
        
        Offset: Avançada
      - VIEW
        
        Create View nomeView
        
        As Select * From tab
        
        Select * From nomeView
        
        Drop nomeView