How to put two conditions in one trigger?

Question

MySQL

BEGIN
    IF ((SELECT SUM(field_310) FROM app_entity_8 WHERE field_581=(SELECT `id` FROM `app_entity_9`))=(SELECT `field_329` FROM `app_entity_9`)) THEN
        UPDATE `app_entity_9` SET `field_586`=53 WHERE `app_entity_9`.`id`=new.field_581;
    END IF;
    IF ((SELECT SUM(field_310) FROM app_entity_8 WHERE field_581=(SELECT `id` FROM `app_entity_9`))<(SELECT `field_329` FROM `app_entity_9`)) THEN
        UPDATE `app_entity_9` SET `field_586`=54 WHERE `app_entity_9`.`id`=new.field_581;
    END IF;
END

This trigger does not work (1242 - Subquery returns more than 1 row), but if you remove the second condition, it works. What am I doing wrong?

Answer 1

the text of the error says what you are doing wrong