how to print some message after firing after trigger in mysql

Posted by Shanky11 under Others on 10/11/2012 | Points: 10 | Views : 6214 | Status : [Member] | Replies : 0
how to print some message after firing after trigger in mysql
-----------------------------------------
--HOW TO PRINT SOMNE MESSAGE AFTER INSERTION ON TABLE THORUGH FIRING TRIGGER-----------------------------------------
create trigger trginsert after insert on registration
for each row
begin
declare msg varchar(100);
set msg ="Congrates Submitted Successfully";
print msg;
end;
---------------------------------------
-------------------HOW CANE WE DO THE ABOVE SCENARIO




Responses

(No response found.)

Login to post response