使用pymysql查询数据库，将结果保存为列表并获取指定元素下标

from pymysql import *
from qmp.config import *


def main():
    conn = connect(host=HOST, port=3306, database=DATABASE, user=USER,
                   password=PASSWORD, charset='utf8')
    cs1 = conn.cursor()
    sql1 = 'SELECT deal_name from ods_project_crawler_seed WHERE round = "-" order by id'
    cs1.execute(sql1)
    pnlist = []
    alldata = cs1.fetchall()
    for singl_company in alldata:
        pnlist.append(singl_company[0])

    print('列表总长度: ', len(pnlist))
    cs1.close()
    conn.close()
    print('伯肯森自动化在列表中的下标为: ', pnlist.index('伯肯森自动化'))


if __name__ == '__main__':
    main()

运行结果

列表总长度:  271270
伯肯森自动化在列表中的下标为:  1934