python3连接mysql

#!/usr/bin/python3

import pymysql

conn = pymysql.connect(host='10.60.10.11',port=3306,user='root',passwd='xxxxx',db='haoxx')

cur = conn.cursor()

cur.execute("select car_id,car_name from car where car_id < 5")

for i in cur.fetchall():
    print(i)

cur.close()
conn.close()
原文地址:https://www.cnblogs.com/vijayfly/p/6914097.html