MySQL存儲(chǔ)過程和觸發(fā)器的簡單學(xué)習(xí)

pgt112you

--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 ;