python链接mysql pymysql

概述python链接mysql import pymysqlconn = pymysql.connect(user=‘user1‘, password=‘123456‘, database=‘gbt2019‘, charset=‘utf8‘)cursor = conn.cursor()query = (‘select id, title from data_2019100501‘)

python链接MysqL

import pyMysqLconn = pyMysqL.connect(user=‘user1‘,password=‘123456‘,database=‘gbt2019‘,charset=‘utf8‘)cursor = conn.cursor()query = (‘select ID,Title from data_2019100501‘)cursor.execute(query)for (ID,Title) in cursor:    print(ID,Title)cursor.close()conn.close()

总结

以上是内存溢出为你收集整理的python链接mysql pymysql全部内容，希望文章能够帮你解决python链接mysql pymysql所遇到的程序开发问题。

如果觉得内存溢出网站内容还不错，欢迎将内存溢出网站推荐给程序员好友。