在多个数据库上安装存储过程 [英] Install Stored Procedure on Multiple Databases

问题描述

有没有办法轻松地一次在多个MySQL数据库上创建存储过程?所有数据库都在同一MySQL安装上.

Is there any way to easily create a stored procedure on multiple MySQL databases at once? All the databases are on the same MySQL install.

推荐答案

如果每个数据库模式仅可用于该模式，我建议进行复制粘贴并在每个数据库模式中创建存储过程.否则，我将遵循"Kelly Vista"的建议，只引用位于其中一个模式中的存储过程.

I would recommend doing a copy-paste and create the stored procedure in each database schema if they need to be available to that schema only. Otherwise I would follow the recommendation from 'Kelly Vista' and just refer to the stored procedure located in one of the schema's.

这篇关于在多个数据库上安装存储过程的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！