Python: MySQLdb

gistfile1

import MySQLdb
db = MySQLdb.connect(host="localhost",\
user="USERNAME",\
passwd="PASSWORD",\
db="DB_NAME",\
charset="utf8")

cursor = db.cursor()

sql = "SELECT a,b FROM sometable"
cursor.execute(sql)

data = cursor.fetchall()

for record in data:
    a, b = record
    print a, b

db.close()