What we can reproduce with this schema is that if more rows have the same value for the numerical field and you change that numerical field (not a text filed) SQLyog sends SQL like
Code:
update `tbl_requetes` set `Req_ID`='abc',`Req_Sql`='def', `Req_Param`='ghi' ,`Req_Description`='jkl' ,`Req_Type`='2' ,`Req_Libelle`='mno' where `Req_Type`='1';
what results in all rows having `Req_Type`='1' to become updated even if the text fileds are not identical.
The where-clause:
Code:
where `Req_Type`='1';
would be OK if that field was a PK. But it is not and it is a bug.