Python + Mysql 数据库 通信 解决方案
Python + Mysql 数据库 通信 解决方案
解决方案:
https://www.cnblogs.com/Qi77/p/12496822.html
pip install pymysql
import pymysql # 打开数据库连接 db = pymysql.connect("localhost","root","12345","centralsystem" ) # 使用 cursor() 方法创建一个游标对象 cursor cursor = db.cursor() # 使用 execute() 方法执行 SQL 查询 cursor.execute("SELECT VERSION()") # 使用 fetchone() 方法获取单条数据. data = cursor.fetchone() print("Database version : %s " % data) sql = "SELECT * FROM t_user WHERE USER_ID > %d" % (1) try: # Execute the SQL command cursor.execute(sql) # Fetch all the rows in a list of lists. results = cursor.fetchall() for row in results: #print (row) id = row[1] userName = row[2] RealName = row[3] PassWord = row[4] Email = row[5] Mobil = row[6] # Now print fetched result print ("userName,RealName = %s %s,PassWord = %s, Email= %s,Mobil = %s" % \ (userName, RealName, PassWord, Email, Mobil )) except: import traceback traceback.print_exc() print ("Error: unable to fetch data") # 关闭数据库连接 db.close()