Dr Karl Stolley

Assistant Professor of Technical Communication, Illinois Institute of Technology

Items Tagged ‘MySQL’

Note
- February 11, 2008
- 15:30PM
When using the UNION syntax in MySQL, it is essential that the order of fields in subsequent SELECT statements match the order (and number) in the first statement.

MySQL AB :: Structure Means Subqueries: Nesting SELECTs in MySQL 4.1: I still really don't get subqueries. Or, maybe I just am not using databases in such a way as to use them properly. (November 27, 2007)
MySQL AB :: MySQL 3.23, 4.0, 4.1 Reference Manual :: 12.11.1 GROUP BY (Aggregate) Functions: Not sure about how well this will optimize, but it's making my home-grown tagging system a little easier to pull out of the db. (November 27, 2007)
Unicode Data with PHP 5 and MySQL 4.1: Can't seem to get these suggestions to work. (October 04, 2007)
MySQL SQL Syntax and Use > Retrieving Records from Multiple Tables: Pre-MySQL five but does a good job of explaining joins and unions (June 12, 2007)

On Twitter: Pretty darned pleased with the article proposal Colin and I put together. We'll see what the editors think.