sql中update时,为多列设置值时,列与列之间不能用 and ,必须是用逗号 sql的update语法错误 eg: update Person set name = ‘auhnayuiL’ and age = 1 where id = 1; 改and为, update Person set name = ‘auhnayuiL’ , age = 1 where id = 1;