Hi, > >> > 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.
Good. Thanks. Hopefully in 5.0.1 then :-) With regards, Martijn Tonies Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL Server. Upscene Productions http://www.upscene.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]