MySQL Forums
Forum List  »  InnoDB

Update... WHERE not same result as SELECT
Posted by: Christian Clement
Date: May 06, 2017 03:14PM

Hi,

When I execute the following SQL I get a result of 1 record found
select COUNT(*) FROM T_Porte
WHERE Territoire=10 and Rue='Ch Clément N' and Ville='St-Justin' and Porte=990 and Appartement='';

When I execute the following SQL I get a result of 0 record change
UPDATE T_Porte
SET Commerce = '0', CAMLM = '0', TerCom = Null, Fictif = '0'
WHERE Territoire=10 and Rue='Ch Clément N' and Ville='St-Justin' and Porte=990 and Appartement='';

Please remark that the WHERE clause is exactly the same.

Why I do not have the same result ?

Thank you,

Christian

P.S:. I may post screen shot but I don't know how...

Options: ReplyQuote


Subject
Views
Written By
Posted
Update... WHERE not same result as SELECT
204
May 06, 2017 03:14PM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.