"Martijn Tonies" <m.tonies@stripped> wrote:
>> > When creating a stored procedure, what must I do to
>> > create a procedure/function in a specific database?
>> > I created a function "hello" like in the example, but
>> > afterwards, I cannot create it from another database
>> > connection.
>> Currently you can't create SP in the particular database.
>> > The column "db" stays NULL in table "procs".
>> > Any idea?
>> Column 'db' in the table 'proc' isn't used yet. It's for future use.
> Thank you for your answer. Can I expect procedures/functions
> to be database specific in the future? Or will they stay server-wide?
> IMO, they should be db specific :-)
Yes, you can. In a future they will be database specific.
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Victoria Reznichenko
/ /|_/ / // /\ \/ /_/ / /__ Victoria.Reznichenko@stripped
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net