SQL Tutorials and Best Practices

From #mysql Freenode

• BINARY attribute for the weak
• Basic Views
• Normalization
• Using Replication
• Using MySQL Cluster
• ALTER TABLE - Setting MAX_ROWS
• Autoincrement FAQ
• Zerofill
• Unique/Distinctive Selection
• Trees and hierarchical data in SQL

Best Practice

• Proper Indexing Strategy
• Basic Debugging

Tutorials

• Basic SQL Statements
• Introduction to Joins
• More Advanced Joins

Specific solutions

• Selecting from groups
• Single table restore, How do I restore a single database or table out of an all-inclusive dump?
• Drop All Tables
• Select rows in table A that are not in table B