(Rob Gravelle) The SELECT statement is without question the most complex amongst MySQL’s data manipulation statements. This article covers the syntax of the SELECT statement, exploring its many optional clauses.

To get information from a database it is necessary to execute a query to get this data.

(Leo Hsu and Regina Obe) In part 1 of this series on PostgreSLQ 9.0 planner outputs, we demonstrated how to render explain plans in YAML, JSON, and XML using the new explain features in PostgreSQL 9.0. In this second part, we’ll demonstrate how to build a user interface that allows you input a JSON

(Darren Cassar) Sometimes we have some special need for a stored procedure to call another to do something. That is fine, but what if the second stored proc failed for some reason? Maybe you want to halt the first stored procedure (the caller) and not proceed with the work until the problem is verif

(Anders Karlsson) In the previous post, I showed how the “virtual tables” that the InnoDB Plugin use for finding lock contention works, and what they look like. I also showed what an InnoDB lock graph looks will look like when monitored from MyQuery 3.3, which is not yet, but soon, released.

(Scott Noyes) Implement multi-master to single-slave replication by periodically saving state and changing masters, and do it all in SQL.*

(Anders Karlsson) When you use InnoDB, or any other RDBMS or storage engine that supports row level locking and transactions, you get to realize a few things:

(sasha) I recently encountered an interesting case. A customer reported that mysqld crashed on start on OpenSUSE 11.2 kernel 2.6.31.12-0.2-desktop x86_64 with 96 GB RAM when the innodb_buffer_pool_size was set to anything more than 62 GB. I decided to try it with 76 GB. The error message was an as

(Leo Hsu and Regina Obe) PostgreSQL offers several options for displaying and querying tree like structures. In Using Recursive Common Table Expressions (CTE) to represent tree structures we demonstrated how to use common table expressions to display a tree like structure. Common Table Expressions r

(Sean Hull) Increasingly, enterprises are looking at cloud services such as Amazon Web Services for their deployments. At first glance, you might be thinking about virtualization based on how it works on the desktop. However, datacenter virtualization is much more sophisticated, providing a whole su