python链接mysql

import mysql.connector
conn = mysql.connector.connect(user='root', password='root', database='fm060')
cursor = conn.cursor()
cursor.execute('select * from admin')
values = cursor.fetchall()
print(values)
cursor.close()

cursor = conn.cursor()
cursor.execute('select * from cssa')
b = cursor.fetchall()
print(b)

  

posted @ 2018-05-28 23:12  fm060  阅读(123)  评论(0)    收藏  举报