pymysql之cur.fetchall() 和cur.fetchone()用法

import pymysql,hashlib
结果：单条结果  {'id': 1, 'name': '打车', 'phone': '132453'}

sql = 'select * from zxj'
def op_mysql(sql,many=True):
    db_info = {'user': 'jxz', 'password': '123456',
            'host': '118*******', 'db': 'jxz', 'port': 3306, 'charset': 'utf8',
            'autocommit': True}
    conn = pymysql.connect(**db_info)  # 建立连接
    cur = conn.cursor(pymysql.cursors.DictCursor)  # 游标
    cur.execute(sql)  # 执行sql语句，insert 、update 、delete
    if many:
        result = cur.fetchall()
        print('多条',result)
    else:
        result = cur.fetchone() # {''}
        print('dantiao',result)
    cur.close()
    conn.close()
    return result
op_mysql(sql,many=False) # 传入sql, 默认为true

==============================================================
md5加盐2
def md5(s,salt=''):
    new_s = str(s) + salt
    m = hashlib.md5(new_s.encode())
    return m.hexdigest()```