Please enable JavaScript.

Coggle requires JavaScript to display documents.

MySQL Refresh Web2 (illustration (university; ntnu (Students, Teachers,…

- - - - CHAR(N) - EX. HELLO = 5 CHARS
      - VARCHAR(n) - bytes (space uses more byte..)
      - tinyrext, text
      - mediumtext / longtext
      - Text vs varchar
        
        text columns = separate objects
        
        varchar is better, faster...
      - BLOB
        
        TinyBLOB
        
        to 255
        
        BLob
        
        up to 65535
        
        medumblob(n)
        
        16777215
        
        Longblob
        
        4290000000 (?)
      - numerical
        
        TinyINT
        
        SmallINT
        
        mediumINT
        
        INT
        
        BIgINT
        
        Float
        
        Double
    - - at the expense of a slight memory and disk space overhead, you can create indexes to conduct lightning fast searches
      - fulltext index
        
        super fast searches
        
        only for certain table types