Thursday, February 6, 2020

Basic Datatypes

Numeric Types


  • INT
  • SMALLINT
  • TINYINT
  • MEDIUMINT
  • BIGINT
  • DECIMAL
  • NUMERIC
  • FLOAT
  • DOUBLE
  • BIT
String Types

  • CHAR
  • VARCHAR
  • BINARY
  • VARBINARY
  • BLOB
  • TINYBLOB
  • MEDIUMBLOB
  • LONGBLOB
  • TEXT
  • TINYTEXT
  • MEDIUMTEXT
  • LONGTEXT
  • ENUM
Data Types

  • DATE
  • DATETIME
  • TIMESTAMP
  • TIME
  • YEAR
at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Right Joins

-- OUR FIRST RIGHT JOIN (seems the same as a left join?) SELECT * FROM customers RIGHT JOIN orders     ON customers.id = orders.custom...

  • Primary Keys
    CODE: Primary Keys Define a table with a PRIMARY KEY constraint: CREATE TABLE unique_cats ( cat_id INT NOT NULL , name ...
  • Setting Default Values
    CODE: Setting Default Values  Define a table with a DEFAULT name specified: CREATE TABLE cats3 ( name VARCHAR ( 20 ) DEFAUL...
  • Aggregate functions: MIN and MAX
    SELECT MIN ( released_year ) FROM books ;   SELECT MIN ( released_year ) FROM books ;   SELECT MIN ( pages ) FROM books ;   SELE...