Please enable JavaScript.

Coggle requires JavaScript to display documents.

SQL (3. Operators, Basic SQL Statements, 1. Database Intro) - Coggle…

- - - - SELECT * FROM
        Customers where not
        city ='Berlin' and
        country = 'Germany' and
        PostalCode < 60000 ;
- - - - DataType
        
        Integer
        
        Char
        
        Eg Y,N Gender
        
        Boolean (true/False)
        
        Blob
        
        Storing Images
        
        Storing Large Files
        
        varchar / String
        
        eg: City, Name of something
        
        Always has single quote in condition
        
        Date
        
        TimeStamp
        
        Float
        
        Decimal Number
      - ColumnType
        
        Primary Column
        
        Uniquess for Row.
        uniquely identifies a row entry
        
        Non-Primary
    - - Acutal Data for given Object/ Entity
    - - Primary Key
      - Composite Key
      - Foreign Key