I was reading through SQL in easy steps, 3rd Edition and made it to page 152 where it covered Sub-query calculated fields. It’s a fancy way of saying a SELECT statement within a SELECT statement, but isn’t that hard to grasp if you’re familiar with how variable interpolation works with Bash or similar shells.
My problem was understanding how even though a column wasn’t listed as one to be returned by SELECT it was seemingly returned as a byproduct of an ORDER BY statement. I couldn’t find this mentioned in any of the MySQL documentation or another MySQL book I have so I was getting pretty frustrated. I fired my MySQL this morning and opened up subquery-calc.sql and had a good laugh: The mental block I was having was due to an error in the book’s code that wasn’t present in the SQL file.
I fired off an errata report in the hopes that it will be correct in future printings so others won’t be as confused as I was.
It probably comes as no surprise, but content gets shuffled about and at some point gets lost, misplaced or thrown away. I’m hoping this isn’t a case of the latter, but Francis’ homepage is giving the dreaded 404 error when trying to view the resources page for his books.
Thankfully I’ve previously created a PDF of the errata page and have downloaded all material, but if you’re one of those who haven’t yet, please see these resources kindly provided by Jaime Moreno here and here. Of particular note is the link to building the fgw library on Mac OS X.
In addition, I have instructions for how to compile the library using Quincy 2005 (the book uses Quincy 2002) and the current MinGW here.
I hope this helps someone.
Those instructions also provide a link to a public Subversion repository that contains revisions of the library from the book’s accompanying CD, the author’s website and from the publisher’s website for the book.
This is a continuation of the previous post
After a bit of cleanup, I’ve got section 1 of 5 of the FREESCO 0.2.7 Bootable CD guide moved to the new wiki here: http://wiki.whyaskwhy.org/GNU_Linux/FREESCO/.
Wow, talk about a walk back in time! I first started working with FREESCO about 10 years ago and I still see traffic in the web server logs from folks looking for the guide. After having it offline for several years where it collected dust with the rest of the website I took offline in late 2006, I decided I’d start resurrecting the content where others could find it.
Hope it helps someone.
Often they’re just from bots banging on your box trying to find some software that can be exploited, but sometimes they’re also from content getting moved over the years and redirects never worked into the plan. Wikis have the right idea when you move something and they offer to leave a redirect behind so visitors can still find the content they’re looking for.
I used to give more weight to 404 entries, and I figure it’s probably time I did so again. With the recent move to MediaWiki and my finding it easy to work with, there is little reason aside from time that I can’t resurrect old site content and place it there.
I’ll start with an older guide I had to converting a default floppy-disk-based FREESCO 0.2.7 installation to a bootable CD. If I were to have one project that I’ve ever worked on that really brought me joy, it would be that one. The feeling as a newbie of overcoming the, “It can’t be done”, mentality was amazing.
Anyway, the new section for the FREESCO articles I posted years ago can be found here: http://wiki.whyaskwhy.org/GNU_Linux/FREESCO
Note: There is a newer version of this document here.
For all steps listed, I’m working with an Ubuntu 10.04 LTS virtual machine. It consists of a single disk (/dev/sda) that I didn’t size properly when I originally created the VM.
Later I added a second disk (/dev/sdb, independent of snapshots) to hold audio files from ripping cds prior to transferring to them to a player. I did not add this disk to the existing logical volume.
Now we’re going add a third disk (/dev/sdc) to the VM and place it in the same volume group as the original disk to help alleviate the space problem as shown here:
Filesystem Size Used Avail Use% Mounted on
7.3G 6.5G 487M 94% /
none 245M 264K 244M 1% /dev
none 249M 1.1M 248M 1% /dev/shm
none 249M 92K 249M 1% /var/run
none 249M 0 249M 0% /var/lock
none 249M 0 249M 0% /lib/init/rw
/dev/sda1 236M 54M 170M 24% /boot
/dev/sdb1 30G 497M 30G 2% /media/bucket
.host:/ 79G 68G 12G 86% /mnt/hgfs