Truncated incorrect DOUBLE value: 'deleted'

注意 sql update的语法啊已经被这个问题纠结过N次了，每次都搞得头晕眼花

sql = "update netpro_sys_subindex set index_states='deleted' and snapshot_name='"+ snapshotName +"' where sid="+ tmpSid +" and del_flg=0";

statement.executeUpdate(sql);