如何查询MySQL中的数据

[Sogrey]

select

import json
def selectRecords(db):
    cursor = db.cursor()
    sql = 'select name,age,salary from persons order by age desc'
    cursor.execute(sql)
    results = cursor.fetchall()
    print(type(results))
    fields = ['name','age','salary']
    records = []
    for row in results:
        records.append(dict(zip(fields,row)))
    return json.dumps(records)


print(selectRecords(db))
db.close()

如何创建MySQL数据表 #74
如何向MySQL表中插入数据 #75