just like this sql:
update user set name = ?, password = ?, mobile = ?, gender = ?, nickname = ?, type = ?, create_at = ?, update_at = ? where id = ? and name != '';
update user set name = ?, password = ?, mobile = ?, gender = ?, nickname = ?, type = ?, create_at = ?, update_at = ? where id = ? and name <> '';
just like this sql:
update
usersetname= ?,password= ?,mobile= ?,gender= ?,nickname= ?,type= ?,create_at= ?,update_at= ? whereid= ? and name != '';update
usersetname= ?,password= ?,mobile= ?,gender= ?,nickname= ?,type= ?,create_at= ?,update_at= ? whereid= ? and name <> '';