from pymysql import *
def demo():
'''
查询数据库某一列保存为list
:return:None
'''
conn = connect(host=' ', port=3306, database=' ',
user=' ',
password=' ', charset='utf8')
cs1 = conn.cursor()
sql1 = "SELECT 列名 FROM 表名 "
cs1.execute(sql1)
datalist = []
alldata = cs1.fetchall()
for s in alldata:
datalist.append(s[0])
print(datalist)
if __name__ == '__main__':
demo()
python查询数据库某一列保存为list
最新推荐文章于 2025-06-23 07:00:00 发布