mysqljava
sql语句:
string tel = obj.getstring(tel);
string email = obj.getstring(email);
......
sqls.add(update from user loginname='+uloginname+',username='+username+' where loginname='+loginname+');
sqls.add(update from userinfo loginname='+uloginname+',gender='+gender+',birthday='+birthday+',address='+address+', mobile='+mobile+',tel='+tel+',email='+email+',quanpin='+chnutil.getfullspell(username)+',jianpin='+chnutil.getfirstspell(username)+' where loginname='+loginname+');
错误信息:
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 'from userinfo loginname='s123',gender='0',birthday='2015-12-10',address='1111',m' at line 1
我要往两个表里更改这些信息,但是出错了。初学者,不知道怎么错了