|
import pymysql
import pandas as pd
db = pymysql.connect(host="127.0.0.1",
port=3306,
user="root",
password="root",
db="hps",
charset="utf8")
cursor = db.cursor()
# SQL 查询语句
sql = "SELECT * FROM method"
try:
# 执行SQL语句
cursor.execute(sql)
# 获取所有记录列表
results = cursor.fetchall()
print (results)
fname = row[1] #读取的公式
# 打印结果
print(fname) #可以正常读取公式I =S/U
U = 10.5
S = 50000
???问题下边如何计算 出I的值
print(X)
except:
print ("Error: unable to fetch data")
# 关闭数据库连接
db.close()
请大神帮忙
|
|