如何使用pymysql实现Python与MySQL数据库的连接？
- 内容介绍
- 文章标签
- 相关推荐
本文共计67个文字，预计阅读时间需要1分钟。
pythonimport pymysqlconn=pymysql.connect(user='user1', password='123456', database='gbt2019', charset='utf8')cursor=conn.cursor()query=SELECT id, title FROM data_2019100501cursor.execute(query)
python链接mysql
import pymysql conn = 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()
本文共计67个文字，预计阅读时间需要1分钟。
pythonimport pymysqlconn=pymysql.connect(user='user1', password='123456', database='gbt2019', charset='utf8')cursor=conn.cursor()query=SELECT id, title FROM data_2019100501cursor.execute(query)
python链接mysql
import pymysql conn = 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()