MySQL query in Python – Python

Just for my own reference.

Install the mysql Module

bash$: sudo port install py27-mysql

Connect and make query

Very, very, very, very basic.

import MySQLdb

# connect to the database

# then get the cursor

# now we can make a query with execute
cur.execute('SELECT `theColumn` FROM `theTable`')

# print the fuckers

for i in range(numRows):
	print row[0]

More info:

MySQL Python tutorial

Leave a Reply

Please log in using one of these methods to post your comment: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s