Re: Get the schema name from inside a stored-procedure
> 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.
Subject
Views
Written By
Posted
4648
July 18, 2014 11:39AM
Re: Get the schema name from inside a stored-procedure
1714
July 19, 2014 09:19AM
1833
July 19, 2014 12:16PM
1910
July 20, 2014 05:45PM
1507
July 20, 2014 07:42PM
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.