/mysql-BASIS

Lesson 2

  1. Join
    1. left, right, inner
  2. Relatives
    1. 1:1

Lesson 1

  1. Basic functions:
    1. insert value in tables
    2. basic search, like, "%a%a_", <>, or, and, not, in lenght('field'')
    3. filter - order by (desc)
    4. limits, pagination - limit 2, offset 2
    5. aggregation functions MIN,MAX,AVG,COUNT
    6. group by
    7. distinct - unique data
    8. union - 2 search in 1

  1. Create, delete, update tablets