The Archives

archived blog posts
Querying MySQL tables with Python and MySQLdb
07.19.09 | Permalink | Comment?

Previously I made a blog post regarding installing mod_python. Now I will share with you how to query mysql tables with Python and MySQLdb. Installing MySQLdb If we want to check if mysqldb is already installed, type ‘python’ on the commandline and then, type ‘import MySQLdb’. If it does not respond to an error, it [...]
archived blog posts
A complicated SQL Query needed at work
11.10.08 | Permalink | 2 Comments

There was this cron job that I made that saves daily on-hand quantity of our items/goods, and my boss just needed one of our principal’s items trade prices with VAT be computed with that data for the month of July this year.