才學mysql沒多久但每次布置的作業超難懂。麻煩各位幫忙看一看第二題！到底是用存盤程序還是事務還是一起用？
uj5u.com熱心網友回復：
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
//
轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/18329.html
標籤：MySQL
上一篇：索引有點不懂求有經驗人士指點