python 寫入MySQL 報錯
uj5u.com熱心網友回復：
可以試下這樣
cursor = conn.cursor()
sql = """
INSERT INTO runoob_tb1(runoob_title, runoob_author) VALUES (%s, %s)
""" % (1, 2)
cursor.execute(sql)
conn.commit()
cursor.close()
conn.close()
uj5u.com熱心網友回復：
現在報錯缺少一個必須位置引數argsuj5u.com熱心網友回復：
cursor = conn.cursor()
sql = """
INSERT INTO runoob_tb1(runoob_title, runoob_author) VALUES (%s, %s)
"""
cursor.execute(sql, (1, 2))
conn.commit()
cursor.close()
conn.close()
uj5u.com熱心網友回復：
cursor = conn.cursor()
sql = """
INSERT INTO runoob_tb1(runoob_title, runoob_author) VALUES (%s, %s)
"""
ins_data = ('a', 'b')
cursor.execute(sql, ins_data )
conn.commit()
cursor.close()
conn.close()
轉載請註明出處，本文鏈接：https://www.uj5u.com/qita/90902.html