python快速访问mysql

import pymysql


# 创建表
def get_conn():
    return pymysql.connect(host='10.0.0.13',user='lyf',password='lyf',db='test',port=3486,charset='utf8',cursorclass= pymysql.cursors.DictCursor)#连接数据库 

# 查询表数据
def query(sql):
    db= get_conn()
    cursor = db.cursor()
    cursor.execute(sql)
    # 返回所有数据
    class_list = cursor.fetchall()
    
    cursor.close()
    db.close()
    return class_list
    
if __name__ == '__main__':
    # 1、取数据库最后一行数据
    get_params=query("select * from `img_params` order by id desc limit 1")[0]