在表设计中,选中触发器一栏,填写好基本属性,在下方定义中写SQL,如:
begin
set NEW.undertaker_id=trim(NEW.undertaker_id);
set NEW.undertaker_id=trim(' ' FROM NEW.undertaker_id);
end
在表设计中,选中触发器一栏,填写好基本属性,在下方定义中写SQL,如:
begin
set NEW.undertaker_id=trim(NEW.undertaker_id);
set NEW.undertaker_id=trim(' ' FROM NEW.undertaker_id);
end