python链接mysql pymysql
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()
QQ 3087438119