sql语句错误，看着晕。

Question

String sql="update userInfo set(NAME=?,EMPCODE=?,DEPTCODE=?,SEX=?,TEL=?,MOBILE=?,STATE=?,USERTYPE=?,ADDRESS=?,POSTALCODE=?,STATION=?,QQ=?) " +
" 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 '(NAME='é?????',EMPCODE='E0132',DEPTCODE='dept09',SEX=2,TEL='',MOBILE='',STATE=4,' at line 1

Answer 1

去掉圆括号。基本语法查下帮助手册，通常有例子的。