DECLARE EXIT HANDLER FOR SQLEXCEPTION 
BEGIN
      ROLLBACK;
END;
START TRANSACTION;
    .. Query 1 ..
    .. Query 2 ..
    .. Query 3 ..
COMMIT;

mysqld -V
mysqld  Ver 5.5.50-0ubuntu0.14.04.1-log for debian-linux-gnu on x86_64 ((Ubuntu))

SELECT @error_count := @@error_count;
START TRANSACTION;
INSERT INTO `tree` (`pid`, `header`)
VALUES
 (null, '1')
,(1, '2')
;

SELECT IF(@@session.error_count>@error_count,ROLLBACK,COMMIT);
IF ... THEN
	ROLLBACK
ELSE
	COMMIT;
END;

SET AUTOCOMMIT = 0; SET FOREIGN_KEY_CHECKS = 0; SET UNIQUE_CHECKS = 0;
truncate `treerel`;
truncate `tree`;
SET AUTOCOMMIT = 1; SET FOREIGN_KEY_CHECKS = 1; SET UNIQUE_CHECKS = 1;

SELECT * FROM tree;


SELECT @error_count := @@error_count;
START TRANSACTION;
INSERT INTO `tree` (`pid`, `header`)
VALUES
 (null, '1')
;
INSERT INTO `tree` (`pid`, `header`)
VALUES
 (1, '1')
;
INSERT INTO `tree` (`pid`, `header`)
VALUES
 (null, '2')
;
SET @sql = (SELECT IF(
    @@session.error_count>@error_count,
    "ROLLBACK;",
    "COMMIT;"
));
PREPARE stmt FROM @sql;
EXECUTE stmt;

SET @sql = (SELECT IF(
    @@session.error_count>@error_count,
    "ROLLBACK;",
    "COMMIT;"
));
PREPARE stmt FROM @sql;
EXECUTE stmt;

INSERT INTO `tree` (`pid`, `header`) VALUES (null, '1');
INSERT INTO `tree` (`pid`, `header`) VALUES (1, '1');
INSERT INTO `tree` (`pid`, `header`) VALUES (null, '2');

#/bin/bash
export MYSQL_PWD="************"
mysql -uroot -Dtreect2 -e "START TRANSACTION;"
mysql -uroot -Dtreect2 < bashtransaction.sql
if [[ $? -eq 1 ]]
	then
		mysql -uroot -Dtreect2 -e "ROLLBACK;"
        echo -e "Ошибка, откат."
	else
		mysql -uroot -Dtreect2 -e "COMMIT;"
        echo -e "Ок, коммит."
fi

exec 3> >(mysql)
echo "SELECT 1;" >&3
echo "SELECT 2;" >&3
exec 3>&-

INSERT INTO `tree` (`pid`, `header`) VALUES (null, '1');
INSERT INTO `tree` (`pid`, `header`) VALUES (1, '1'); -- Тут д.б. ошибка т.к. поле header - uq
INSERT INTO `tree` (`pid`, `header`) VALUES (null, '2');

$ mysql -uroot -Dtreect2 -p -e "START TRANSACTION; source bashtransaction.sql; COMMIT;"
Enter password: 
ERROR 1062 (23000) at line 2 in file: 'bashtransaction.sql': Duplicate entry '1' for key 'uq_tree_header'

SELECT * FROM tree;