python链接mysql pymysql
标签：set mysq print mysql password sql ase cursor base
python链接mysql pymysql
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()