delimiter //
create trigger getval
before insert on message
for each row
begin
declare code int;
declare prob varchar(50);
declare hospid int;
declare docid int;
declare msgin int;
set msgin=(select new.type from message);
if msgin = 2 then
truncate table keyword;
truncate table keywordaction;
set code =(select substring(new.textContent, 1,6) from message);
set prob =(select substring(new.textContent, 7) from message);
set hospid =(select hosp_id from hosp where postalcode=code);
set docid =(select doc from doctor where hosp_id=hospid);
insert into keyword values(3,'',code);
insert into keywordaction values(1,0,'aj tu marja doctor kal nu ayega',0,null,null,0,null,null,null,null,0,4,null,null,3);
end if;
end;//