Category Archives: MySQL


Eclipse + ZendStudio + ZendServer + Android SDK = Awesome IDE

Recently installed the Zend Studio for Eclipse and took it upon myself to get Android Development setup as well.  I also found Magento works best with ZendServer, although it does require a few work arounds to get Magento to work with ZendServer. However with that being said I’m pretty much happy to have one IDE that

Continue reading »

Selecting 30 days or older entries using MySQL DateTime field

I’ve been doing quite a bit of Date and Time manipulations lately, and have grown to enjoy MySQL’s DateTime fields just as much as UNIX timestamps. Particularly its built-in functions for selecting any range of fields based on a time frame. Needing to remove all entries from a table that are older than 30 days,

Continue reading »