Playing with MySQL

In this column I throw in my ideas from time to time. Funny stuff like the Briefkasten or more interesting stuff like handling tree structures in SQL.

• Sub-Queries

  • Group-Wise Maximum
  • Optimizing ORDER BY RAND

• User Defined functions - sending mail from within MySQL

• Stored Procedures and Triggers

  • more work on the tree classes
  • getting parent, childs from a node
  • calculating the depth of the tree
  • modifying the tree

• MySQL Proxy

• MySQL Protocol

• … more