我的目的是想生成下面的内容,动态语句不能生成触发器所以要导出到文本中在执行 delimiter $$ \ aa Drop Trigger tbi_test; $$\ Create Trigger tbi_test\ BEFORE INSERT ON test\ FOR EACH ROW Begin \ Declare ad_prseno bigint(16) ; \ IF NEW.PRSENO <= 0 OR NEW.PRSENO IS NULL THEN \ set NEW.PRSENO = nextval('SEQ_PRSENO') ; \ end if ;\ end; $$\ delimiter ;
set Outvalue =CONCAT('a\n',b\n','c\n')
;
select Outvalue into OUTFILE 'c:/a.sql' ;文件效果 a\
b\
c\
abc 不符合我的预期
delimiter $$ \
aa Drop Trigger tbi_test; $$\
Create Trigger tbi_test\
BEFORE INSERT ON test\
FOR EACH ROW Begin \
Declare ad_prseno bigint(16) ; \
IF NEW.PRSENO <= 0 OR NEW.PRSENO IS NULL THEN \
set NEW.PRSENO = nextval('SEQ_PRSENO') ; \
end if ;\
end; $$\
delimiter ;