Session
SQL Kitchen: Spicing Up Everyday SQL
Damien Seguy, Nexen Services SA
Track: General
Date: Thursday, April 26
Time: 1:40pm
- 3:15pm
Location: Ballroom A
Too frequently, we have to fall back to batch programming to process data. Even more frequently, one can actually do all of it in SQL, on MySQL.
2. Filing holes in an auto_increment
3. Calculating ranking from a table
4. Creating an ‘Others’ line for graphs
5. Unsorting: adding chaos to a table!
6. Storing hierarchical data: the classic approach
7. Storing hierarchical data: the smart approach
8. Median value in MySQL
9. Ensuring a group is homogenous
10. Funky sorting with ENUM()!
11. Magic tricks with auto_increments!
12. More with auto_increment: adding to a non-unique column
The features introduced in MySQL 5.0 can handle many real world situations where data need to be kept consistent. Using pure SQL, we will solve problems ranging from ranking to hierarchical data, from unsorting to refactoring tables. This session will cover a list of MySQL best recipes that can save the day when facing one of those strange SQL problems.
1. Refactoring databases with views and triggers2. Filing holes in an auto_increment
3. Calculating ranking from a table
4. Creating an ‘Others’ line for graphs
5. Unsorting: adding chaos to a table!
6. Storing hierarchical data: the classic approach
7. Storing hierarchical data: the smart approach
8. Median value in MySQL
9. Ensuring a group is homogenous
10. Funky sorting with ENUM()!
11. Magic tricks with auto_increments!
12. More with auto_increment: adding to a non-unique column