MySQL Forums
Forum List  »  Stored Procedures

Re: Get the schema name from inside a stored-procedure
Posted by: Peter Brawley
Date: July 19, 2014 09:19AM

> if I call schema1.procedure1(), I want table1 in schema1 to be updated, not table1 in schema2.

MySQL sprocs are defined within specific databases. To have the sproc address objects of other DBs, qualify the object name eg db1.table1.



Edited 1 time(s). Last edit at 07/19/2014 09:19AM by Peter Brawley.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Get the schema name from inside a stored-procedure
1714
July 19, 2014 09:19AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.