python：mysql查询

# coding:utf-8import MySQLdbimport sysconn = MySQLdb.connect('localhost', 'root', '', 'test')cur = conn.cursor()with conn:    cur.execute("select * from yhxtest")    # 输出结果每条记录为一个元组    # rows=cur.fetchall()    # for row in rows:    #     print row    # 输出结果为一个元组    numrows =int(cur.rowcount)    for i in range(numrows):        row = cur.fetchone()        print row[0],row[1]