如何获取已创建ROUTINE LOAD的原始CREATE ROUTINE LOAD 语句?

如何获取已创建ROUTINE LOAD的原始CREATE ROUTINE LOAD 语句?

show create routine load for xxx

没这个语法呀,版本2.5.19

show create routine load for load_bitmap\G
ERROR 1064 (HY000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘routine’ at line 1

3.0+才有了,或者看fe.audit.log,也会有记录。

1赞

好的,多谢