python 链接mysql

下载对应版本   安装  

https://dev.mysql.com/downloads/connector/python/    

创建链接

# python 链接mysql
import  mysql.connector
con = mysql.connector.connect(
    host = "localhost",port = "3306",
    user = "root",password = "",
    database = "demo"
)

cursor = con.cursor()
sql = "select empno,ename,hiredate from t_emp;"
cursor.execute(sql)

for one in cursor:
    print(one[0],one[1],one[2])
con.close()