標(biāo)題: MySQL存儲(chǔ)過程和觸發(fā)器的簡(jiǎn)單學(xué)習(xí) [打印本頁] 作者: pgt112you 時(shí)間: 2011-12-19 13:55 標(biāo)題: MySQL存儲(chǔ)過程和觸發(fā)器的簡(jiǎn)單學(xué)習(xí) --delimiter // --DROP procedure if EXISTS `test_sp1`; --create procedure test_sp1(out p int, in q int) -- begin -- set p = q + 1 ; -- insert into test values(13, p, p); -- end
--DROP TRIGGER IF EXISTS test_trig; DROP TRIGGER test_trig; delimiter // create TRIGGER test_trig before insert on status1 for each row begin insert into status112 values(23,'aa','bb','dd'); end; // delimiter ;