pymysql的列名字传参(1)
def insert(name, value):
# 连接database
conn = pymysql.connect(host=“127.0.0.1”, port=3306, user=“root”, password=“123456”, database=“contract_close”, charset=“utf8”)
# 得到一个可以执行SQL语句的光标对象
cursor = conn.cursor()
sql = ‘INSERT INTO contract_close({keys}) VALUES ({values})’.format(keys=name, values=value)
try:
# 执行SQL语句
cursor.execute(sql)
# 提交事务
conn.commit()
except Exception as e:
# 有异常,回滚事务
conn.rollback()
print(e)
cursor.close()
conn.close()
pymysql的列名字传参(2)
def insert(name, value):
# 连接database
conn = pymysql.connect(host=“127.0.0.1”, port=3306, user=“root”, password=“123456”, database=“contract_close”, charset=“utf8”)
# 得到一个可以执行SQL语句的光标对象
cursor = conn.cursor()
sql = 'INSERT INTO contract_close(Contract_Number) VALUES (%s)'
try:
# 执行SQL语句
cursor.execute(sql, [value])
# 提交事务
conn.commit()
except Exception as e:
# 有异常,回滚事务
conn.rollback()
print(e)
cursor.close()
conn.close()