带 MySQL 连接器的 Python，没有信息发送到数据库

Question

我目前正在尝试使用 python 将数据发送到托管在网络上的数据库。没有抛出 MySql 错误，但是在 ninja 中运行我得到以下输出:

Traceback (most recent call last):
File "/home/nekasus/tryme.py", line 8, in <module>
    port = "3306")        # name of the data base

  File "/usr/lib/python2.7/dist-packages/MySQLdb/__init__.py", line 81,     in Connect
    return Connection(*args, **kwargs)
 File "/usr/lib/python2.7/dist-packages/MySQLdb/connections.py", line 187, in __init__
 super(Connection, self).__init__(*args, **kwargs2)
TypeError: an integer is required

这是我的代码:

import fakevalues
import MySQLdb
fakevalues.randomnumber()
db = MySQLdb.connect(host="sql8.freemysqlhosting.net",
                     user="sql8167767",   
                     passwd="placeholder",  
                     db="sql8167767",
                     port = "3306")       

cur = db.cursor()

try:
     cur.execute("INSERT INTO hydroponics (ph, electricalconductivity, nutrientsolutiontemperature, nutrientsolutiondepth) VALUES (1, 1, 1, 1)")
except MySQLdb.Error as e:
    print(e)
db.close()

Answer 1

您错过了提交。

db.commit()