python mysql insert into_MySQL Python insert添加数据,mysqlpythoninsert

def third_party_insert(clientid,clientkey,redirecturi,clientname):#成功返回1 失败返回-1

try:

connection=pymysql.connect(**config)

except:

print("数据库连接失败")

return -1

'''

cursor = connection.cursor()

sql = "select *from third_party_website"

cursor.execute(sql)

result = cursor.fetchall()

print(result)

sql = "insert into `third_party_website` (`clientid`,`clientkey`,`redirecturi`,`clientname`) values ({0}，{1},{2},{3})".format(

third_party, clientid, clientkey, redirecturi, clientname)

global res

res= cursor.execute(sql)

sql = "insert into `third_party_website` (`clientid`,`clientkey`,`redirecturi`,`clientname`) " \

"values (%s,%s,%s,%s)"

cursor.execute(sql,[clientid,clientkey,redirecturi,clientname])

sql="select *from third_party_website"

cursor.execute(sql)

result = cursor.fetchall()

print(result)

connection.commit()

'''

try:

with connection.cursor() as cursor:

# 创建一条新的记录

sql = "insert into `third_party_website` (`clientid`,`clientkey`,`redirecturi`,`clientname`) " \

"values (%s,%s,%s,%s)"

global res

res= cursor.execute(sql,[clientid,clientkey,redirecturi,clientname])

# 连接完数据库并不会自动提交，所以需要手动 commit 你的改动

connection.commit()

except:

connection.rollback()

print("插入第三方表失败")

connection.close()

return -1

connection.close()

print("插入第三方表成功")

return 1