SQL语句错误，userId就是这样的

Question

String sql="insert into userInfo(NAME,EMPCODE,DEPTCODE,SEX,TEL,MOBILE,STATE,USERTYPE,ADDRESS,POSTALCODE,STATION,QQ) " +
"values(?,?,?,?,?,?,?,?,?,?,?,?) where userId=?";
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 'where userId=1434594273200' at line 1

Answer 1

这样写不对啊，insert插入语句怎么能指定userId；按照你的逻辑应该使用update