mysql - triggers

[Dominik ms]

DELIMITER //
CREATE TRIGGER `ondelete_accounts` BEFORE DELETE ON `accounts`
 FOR EACH ROW BEGIN
	DELETE FROM `bans` WHERE `value` = OLD.`id`;
END
//
DELIMITER ;

Nice, this work fine, but, how to add more than one triggers in this same time??

DELIMITER //
CREATE TRIGGER `ondelete_accounts` BEFORE DELETE ON `accounts`
 FOR EACH ROW BEGIN
	DELETE FROM `bans` WHERE `value` = OLD.`id`;
END
//
DELIMITER ;

DELIMITER //
CREATE TRIGGER oninsert_players AFTER INSERT ON players
FOR EACH ROW BEGIN
    SELECT id FROM accounts WHERE id = NEW.account_id;
END
//
DELIMITER ;

ERROR:

DELIMITER ; DELIMITER // CREATE TRIGGER oninsert_players AFTER INSERT ON players FOR EACH ROW BEGIN SELECT id FROM accounts WHERE id = NEW.account_id; END //

#1415 - Not allowed to return a result set from a trigger