使用python导出mysql数据

最新推荐文章于 2023-06-08 17:19:35 发布

sxf_0123

最新推荐文章于 2023-06-08 17:19:35 发布

阅读量1.1k

点赞数 1

CC 4.0 BY-SA版权

分类专栏： mysql 文章标签： mysql

本文链接：https://blog.youkuaiyun.com/sxf_123456/article/details/80298130

这段代码展示了如何使用Python连接MySQL数据库，并通过SQL查询获取数据。查询涉及光猫信息，如宽带账号、厂商、型号等，并根据指定的本地网ID筛选结果。查询结果将导出为GBK编码的CSV文件。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

import pymysql
"""
,"114000","115000",
               "116000", "117000","118000","119000","120000","121000"
"""
# db = pymysql.connect('0.0.0.0','','','test','utf8')
# localnet_id = ["105000","106000","107000","108000","109000",
#                "110000","111000","112000","113000","114000","115000",
#                "116000", "117000","118000","119000","120000","121000"]
localnet_id = ["105000"]
# localnet_id = ["103000"]
# cursor = db.cursor()
sql =