MySQL Basics II

Topics 

  • Advanced field modifiers 
  • AUTO_INCREMENT 
  • INDEX 
  • UNIQUE 
  • Table modifiers 
  • Storage Engine 
  • Other modifiers 
  • WHERE clause options
  • GROUP BY and HAVING 
  • User-defined variables

Advanced Field Modifiers 

  • AUTO_INCREMENT 
    • MySQL automatically generates a number (by incrementing the previous value by 1) 
    • Used for creating primary key automatically 
  • INDEX 
    • Index a field 
    • When a field is indexed, MySQL no longer has to scan the whole table, instead uses the index to locate the record(s) 
    • Performance booster 
  • UNIQUE 
    • The value has to be unique

 

Download course content