mysql中update192.168.1.100的问题.十万火急!!!!!!!!!!(刚好十个叹号)
hfree 2004-03-02 04:45:59 用mysql数据库,语句:
String task = "UPDATE userdata SET ipaddr="+"192.168.1.111"+"
WHERE number=" + baseID ;
userdata是表名,baseID是用户的ID .
出现报错
java.sql.sqlexception ; syntax error or access violation , message from server: " 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 '.1.111 where number = 1002' at line 1"
请问大虾是什么原因.