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