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

You must have an active subscription to download PDF,Lab Zip and Recordings of this course topic.Please click the "Subscribe" button or the "Login" button if you already have an account.