This page is a placeholder a MySQL page showing essentially a TOC of all MySQL pages.
I’ll be filling these in over time. Please use the comment section to let me any comments or suggestions – thanks!
Basics and Background
- MySQL CREATE TABLE Example Code
- MySQL CREATE TABLE Example Code showing NULLS, default values and comments
- MySQL CREATE TABLE Example Code showing all Integer sizes and ranges of values
- How to create a TIMESTAMP/DATETIME column in MySQL to automatically be set with the current time
- Create tables Like
- Getting the latest definition of a table
- Why views suck
- Insert Example
- Comments and Headers
- Information Functions
Basics and Background – DML
- Insert Examples
- Update Examples
- Comments and Headers
Creating Users and Permissions
- ‘Super Users’
- using special commands
- using base tables
- reload cache
- 4.0 -v- 5.0?
Advanced Query Techniques
- Join examples and syntax
- multi table updates
- Insert on dup key update example
- using explain to look at indexes
- indexing strategies
Stored Procedures and Other Advanced Techniques
- Stored procedure examples/templates
- Example of a mysql stored application that users a cursor
- mysql prepared statements
Logging and Alerts
- Creation of logging stored procedure
- Creation of notification tables
- script to do notifications based on levels
What to do when things get BIG
Backup / Restore
Replication
Dealing with External Data
Advanced Techniques and Design Patterns
When to move on to some other database.