delimiter //
CREATE TRIGGER wyzwalacz AFTER INSERT ON customer FOR EACH ROW
BEGIN
INSERT INTO account VALUES(((SELECT MAX(account.AccNo) FROM account)+1),0,'Bugstone',CURDATE());
INSERT INTO customer_account (RefNo, AccNo) VALUES(NEW.RefNo,(SELECT MAX(account.AccNo) FROM account));
END//
delimiter ;