SQLManager: MySQL Articles(c) 1999-2005 EMS Database Management Solutions, Inc. All rights reserved.http://sqlmanager.net/en/articles/mysqlMySQL Articlesen86400Debunking GROUP BY Mythshttp://sqlmanager.net/en/articles/mysql/1188http://sqlmanager.net/en/articles/mysql/1188This article shows how and why in MySQL, one can write GROUP BY queries that reference non-aggregated columns in the SELECT list that are not included in the GROUP BY clauseStored Procedures in MySQL 5.0http://sqlmanager.net/en/articles/mysql/776http://sqlmanager.net/en/articles/mysql/776Stored Procedures allows to automate or program our way out of many tasks on directly on the server rather than having to write external scripts to do complex manipulation of data.MySQL 5.1's New XML Functionshttp://sqlmanager.net/en/articles/mysql/775http://sqlmanager.net/en/articles/mysql/775MySQL version 5.1.5 has functions for searching and changing XML documents. This article has examples.MySQL 5.0 New Features: Triggershttp://sqlmanager.net/en/articles/mysql/773http://sqlmanager.net/en/articles/mysql/773This article covers MySQL 5.0 support for Triggers using detailed examples, source code, and hands-on exercises.MySQL 5.0 New Features: Data Dictionaryhttp://sqlmanager.net/en/articles/mysql/772http://sqlmanager.net/en/articles/mysql/772This article covers the MySQL 5.0 Data Dictionary using detailed examples, source code, and hands-on exercises.MySQL 5.0 New Features: Viewshttp://sqlmanager.net/en/articles/mysql/771http://sqlmanager.net/en/articles/mysql/771This article covers MySQL 5.0 support for Views using detailed examples, source code, and hands-on exercises.Managing Hierarchical Data in MySQLhttp://sqlmanager.net/en/articles/mysql/725http://sqlmanager.net/en/articles/mysql/725Two models for dealing with hierarchical data in MySQL.A Practical Look at the MySQL Query Cachehttp://sqlmanager.net/en/articles/mysql/704http://sqlmanager.net/en/articles/mysql/704A quick look on how the popular database vendors implement their caching strategies...Point-in-Time Data Recoveryhttp://sqlmanager.net/en/articles/mysql/682http://sqlmanager.net/en/articles/mysql/682Binary logging will slow a server by only one percent. In return, though, it allows for up to the minute data recovery.Choosing the Right MySQL Versionhttp://sqlmanager.net/en/articles/mysql/653http://sqlmanager.net/en/articles/mysql/653Which MySQL version you should use, whether you should consider upgrading, what to do when you find a bug?..MySQL 5.0 New Features: Stored Procedureshttp://sqlmanager.net/en/articles/mysql/652http://sqlmanager.net/en/articles/mysql/652This article shows you how to write stored procedures and shares the implementation details of Stored Procedures in MySQL 5.0.MySQL Network and Youhttp://sqlmanager.net/en/articles/mysql/646http://sqlmanager.net/en/articles/mysql/646MySQL Network is presented in the press. What it all means for you?Prepared Statementshttp://sqlmanager.net/en/articles/mysql/592http://sqlmanager.net/en/articles/mysql/592Benefits (and trade-offs) of the new server-side prepared statements and the support for it from various programming languages.Structure Means Subqueries: Nesting SELECTs in MySQL 4.1http://sqlmanager.net/en/articles/mysql/591http://sqlmanager.net/en/articles/mysql/591Subqueries are another way to get data from multiple tables using a single query, and MySQL 4.1 includes support for this standard SQL construct.New in MySQL 4.1: All the Little Featureshttp://sqlmanager.net/en/articles/mysql/590http://sqlmanager.net/en/articles/mysql/590We've covered the major features in 4.1, now we wrap up our 'New in 4.1' series with an article about all of the little features.