回答此问题可获得 20 贡献值,回答如果被采纳可获得 50 分。
<p>我试过很多次用不同的代码在mysql int unsigned字段中插入一个ip地址,任何指针都可以,我看过google上所有的例子,没有任何帮助</p>
<p>这是我的密码</p>
<pre><code> icecast_source_ip = "INET_ATON('" + icecast_source_ip +"')"
print icecast_source_ip
cnx = mysql.connector.connect(host=mysql_remote_host,
user=mysql_remote_host_user,
password=mysql_remote_host_password,
database=mysql_remote_host_database)
cursor = cnx.cursor()
cursor.execute("INSERT INTO icecast_monitor.status_log
(website_online, icecast_source_online, icecast_source_ip,
icecast_no_listeners, centerpoint_online, centerpoint_connection,
horsleypark_online, horsleypark_connection, system_ok)
VALUES ('" + website_online + "','"
+ icecast_source_online + "','"
+ icecast_source_ip + "','"
+ icecast_no_listeners + "','"
+ centerpoint_online + "','"
+ centerpoint_connection + "','"
+ horsleypark_online + "','"
+ horsleypark_connection + "','"
+ system_ok + "')
")
print 'Data inserted into Database'
cnx.commit()
cursor.close()
cnx.close()
</code></pre>
<p>以及我所犯的错误</p>
<blockquote>
<p>Unexpected error 1064 (42000): You have an error in your SQL syntax;
check the manual that corresponds to your MySQL server version for the
right syntax to use near
'60.241.175.9')','19','True','Main','True','Main','False')' at line 1</p>
</blockquote>