sql="update mt_member set (nicheng,pwd,city,email,birthday,qq) values('"+nicheng+"','"+pwd+"','"+city+"','"+email+"','"+birthday+"','"+qq+"') where UserName='"+userName+"'";
我这个语句错了,可是我不知道怎么改好。就是要更新nicheng,pwd,city,email,birthday,qq,帮忙下好么,谢谢了。
我这个语句错了,可是我不知道怎么改好。就是要更新nicheng,pwd,city,email,birthday,qq,帮忙下好么,谢谢了。
update tablename
set col = @new,
col2 = @new2
....
得用update ta
set .....
where ....
update 表名,set 字段1=value,字段2=value2
where condition