mysql新手上路

[ma??????]

才学mysql没多久但每次布置的作业超难懂。麻烦各位帮忙看一看第二题！到底是用存储过程还是事务还是一起用？

[带我飞的云]

delimiter //
CREATE PROCEDURE test.Delete11(IN xuehao VARCHAR(255))
BEGIN
	DECLARE EXCEPTION INT DEFAULT 0;
	DECLARE EXIT HANDLER FOR SQLEXCEPTION SET EXCEPTION = 1;
	START TRANSACTION;
		DELETE FROM stu WHERE StuID = xuehao;
        DELETE FROM  scores WHERE StuID = xuehao;
    IF EXCEPTION = 1 THEN 
    ROLLBACK;
    ELSE
    COMMIT;
    END IF;

END
//