import MySQLdb

db = MySQLdb.connect(host='localhost', port=3306, user='dave', passwd='evad', db='world')
cur = db.cursor()
cur.execute("set names 'utf8'")

cur.execute("SELECT * from City order by Name limit 3")
#cur.execute("SELECT ID, Name, Population from City order by Name limit 3")

#print cur.description
desc = cur.description

for row in cur.fetchall():
    for info,value in zip(desc,row):
        print info[0], ': ', value

cur.close()
db.close()