Scope of UDF in MySQL

Question

tanha -2 Posting Whiz in Training

8 Years Ago

Hello everyone,

I am creating UDF using CREATE FUNCTION statement.

The question is how can I make them globally accessible to all the databases, rather than specific database?

Regards,

function global mysql scope udf

2 Contributors
3 Replies
123 Views
5 Days Discussion Span
Latest Post 8 Years Ago by smantscheff Latest Post

Be a part of the DaniWeb community

We're a friendly, industry-focused community of 1.18 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.

Sign Up — It's Free!

smantscheff 265 · Answer 1 · 2011-11-16T23:56:46+00:00

Grant access to the UDF to all involved parties and call it with the database name as a dot-terminated prefix, like in

call testDB.myUDF();

tanha -2 · Answer 2 · 2011-11-20T15:26:57+00:00

Thank you for the response.

There is no way omitting the database_name? to write something as follow:

SELECT myUDF();

smantscheff 265 · Answer 3 · 2011-11-21T14:03:20+00:00

The default path to search for database objects is the database currently in use. If there is no object of that name (myUDF) in the database, you have either to switch the database or to include the search path (the database name) in the function call.