When I execute below update query in mysql workbench It will update only 2 rows.
UPDATE usertoken SET StatusName='Completed',Id=null where (UserId=45 and BuddyId=46) OR (UserId=46 and BuddyId=45);
but the same query inside the Stored Procedure updates the entire table.
Even I hardCoded the user id's inside the Stored procedure nothing changed.
Any Idea's?
