create-trigger-insert-pwd

delimiter |  
drop trigger if exists default_insert_Pwd;
create trigger default_insert_Pwd before insert on traceroleid  
  for each row  
     if (new.Pwd is null or new.Pwd='' or new.Pwd='123456' )then  
			 set new.Pwd = ENCODE('123456','password');
     end if;|