programming

modu version 1.0 released!!!

After two years of continual development, documentation, and production use, I've arbitrarily decided to tag modu with a version 1.0, as well as make a formal release.

modu is released under the MIT license. For installation instructions, see Installation or the included INSTALL file.

Tar package

md5sum: 33242ce8c2a3c6292aca46ee563e431b

MySQLs mangled syntax handling and INNER JOINs

As my DBA skills have progressed over the years, I'm always impressed and upset to see the extent to which MySQL has allowed me to use terrible syntax generally not accepted by standards-compliant SQL servers.

A recent one really blew me away, because it exposed a lack of understanding on my part about how to understand the syntax of JOIN commands.

This is how I always built nested JOIN queries. The premise is that semantically you are always selecting from a single table; the use of the INNER JOIN statement is treated like a function that returns a compound table.

Syndicate content