MySql查询——数据库多条件匹配

最新推荐文章于 2024-06-18 17:28:10 发布

fengku1

最新推荐文章于 2024-06-18 17:28:10 发布

阅读量1.2k

点赞数 1

分类专栏： PyMySql 文章标签：数据库 mysql sql

本文链接：https://blog.csdn.net/fengku1/article/details/126772739

版权

PyMySql 专栏收录该内容

1 篇文章 0 订阅

订阅专栏

    type0 = ['ssd_interfaces','form_factor','manufacturer','model']
    data0 = ['PCIe', 'U.2-15','Memblaze','6530']
    conn = pymysql.connect(host='127.0.0.1', port=3306, user='root', passwd='', db='mms',
                           charset='utf8')
    sql=''
    cursor = conn.cursor()
    start = 'select * form ssd where'
    for i in range(len(type0)):
        if i == (len(type0)-1):
            sql += type0[i]+" = "+ f"'{data0[i]}'"
        else:
            sql += type0[i] + " = " + f"'{data0[i]}'" + "  and "
    final_sql = f"select * from ssd where {sql}"
    cursor.execute(final_sql)
    result = cursor.fetchall()
    cursor.close()
    print(result)

type0和data0分别存储的为查询的列名以及需要查询的数据