python3串連mysql

標籤：exec   class   語句   exe   ted   列表   test   sql語句   error:   

import pymysql# 開啟資料庫連接db = pymysql.connect("localhost","testuser","test123","TESTDB" )# 使用cursor()方法擷取操作遊標 cursor = db.cursor()# SQL 查詢語句sql = "SELECT * FROM EMPLOYEE        WHERE INCOME > ‘%d‘" % (1000)try:   # 執行SQL語句   cursor.execute(sql)   # 擷取所有記錄列表   results = cursor.fetchall()   for row in results:      fname = row[0]      lname = row[1]      age = row[2]      sex = row[3]      income = row[4]       # 列印結果      print ("fname=%s,lname=%s,age=%d,sex=%s,income=%d" %              (fname, lname, age, sex, income ))except:   print ("Error: unable to fetch data")# 關閉資料庫連接db.close()

python3串連mysql