Is there a way to view all stored procedures and stored functions in a given database?
Appendix A. Frequently Asked Questions About MySQL 5.1Yes. For a database named dbname, use this query on the INFORMATION_SCHEMA.ROUTINES table: SELECT ROUTINE_TYPE, ROUTINE_NAME FROM INFORMATION_SCHEMA.ROUTINES WHERE ROUTINE_SCHEMA='dbname'; The body of a stored routine can be viewed using SHOW CREATE FUNCTION (for a stored function) or SHOW CREATE PROCEDURE (for a stored procedure). See Section 13.5.4.8, "SHOW CREATE PROCEDURE and SHOW CREATE FUNCTION Syntax", for more information.
Where are stored procedures stored?
Appendix A. Frequently Asked Questions About MySQL 5.1In the proc table of the mysql system database. However, you should not access the tables in the system database directly. Instead, use SHOW CREATE FUNCTION to obtain information about stored functions, and SHOW CREATE PROCEDURE to obtain information about stored procedures. See Section 13.5.4.8, "SHOW CREATE PROCEDURE and SHOW CREATE FUNCTION Syntax", for more information about these statements. You can also query the ROUTINES table in the INFORMATION_SCHEMA database - see Section 22. See similar questions...
Where can I find the ANSI SQL 2003 specification for stored procedures?
Appendix A. Frequently Asked Questions About MySQL 5.1Unfortunately, the official specifications are not freely available (ANSI makes them available for purchase). However, there are books - such as SQL-99 Complete, Really by Peter Gulutzan and Trudy Pelzer - which give a comprehensive overview of the standard, including coverage of stored procedures. See similar questions...
Do stored procedures have a statement for raising application errors?
Appendix A. Frequently Asked Questions About MySQL 5.1Not in MySQL 5.1. We intend to implement the SQL standard SIGNAL and RESIGNAL statements in a future MySQL release. See similar questions...
Do stored procedures provide exception handling?
Appendix A. Frequently Asked Questions About MySQL 5.1MySQL implements HANDLER definitions according to the SQL standard. See Section 18.2.8.2, "DECLARE Handlers", for details. See similar questions...
Do MySQL 5.1 stored procedures and functions work with replication?
Appendix A. Frequently Asked Questions About MySQL 5.1Yes, standard actions carried out in stored procedures and functions are replicated from a master MySQL server to a slave server. There are a few limitations that are described in detail in Section 18.4, "Binary Logging of Stored Routines and Triggers". See similar questions...
Are stored procedures and functions created on a master server replicated to a slave?
Appendix A. Frequently Asked Questions About MySQL 5.1Yes, creation of stored procedures and functions carried out through normal DDL statements on a master server are replicated to a slave, so the objects will exist on both servers. ALTER and DROP statements for stored procedures and functions are also replicated. See similar questions...
How are actions that take place inside stored procedures and functions replicated?
Appendix A. Frequently Asked Questions About MySQL 5.1MySQL records each DML event that occurs in a stored procedure and replicates those individual actions to a slave server. The actual calls made to execute stored procedures are not replicated. Stored functions that change data are logged as function invocations, not as the DML events that occur inside each function. Yes. Because a slave server has authority to execute any statement read from a master's binary log, special security constraints exist for using stored functions with replication. See similar questions...
What is the difference between stand alone procedures and stored procedures?
PL/SQL FAQ - Page 8Latest Answer: An Oracle stored procedure is a program stored in an Oracle databaseStandalone procedures are the pr... See similar questions...
Explore Other Topics
What Is Leasehold Property?What do Dragonflies eat?
How can I verify the status of my EAD application?
M11: How is the numbering of the serial ports under Linux?
How long does bad credit history stay on my credit report?
Why use DC power (rather than AC)?
How does filing under chapter 13 affect a person's credit rating?
To whom should I respond?
How long does the mortgage process take?
How do you do circular interpolation?
Why are some bags marked, "not for individual sale"?
Do I have to begin to withdraw my money from an IRA account at a particular age?
How does acid erosion affect teeth?
Will I be due to pay any monies at the end of my tenancy?
