import MySQLdb

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


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

for row in cur.fetchall():
    print "ID:",row[0], "Name:", row[1], "Pop:", row[2]

cur.close()
db.close()