Where stored procedures are stored in mysql

[waqasahmed996]

Hi

i have study some tutorials of stored procedures for Mysql. I want to know that where stored procedures are saved in Mysql database.

Means if a database exist, how can i check if it has stored procedures.

Thanks

[code green]

They are not stored in your database.
Well I can only speak for phpMyAdmin, the procedures are stored in a table called `proc` in the system database `mysql`

[waqasahmed996]

Thanks for your reply.

If these are not stored in database then where it is stored?

is there any way that i can check stored procedures set for a database?

[code green]

Did you not read my post?
They are not 'set' for any particular database.
They are system procedures and the standard seems to be that they are stored in the `mysql` database in a table called `proc`.
You can query this database like any other.

[waqasahmed996]

Thanks for your reply
but database has no table named 'proc'.

[code green]

Do you have a database called `mysql` within the MySQL environment?

SHOW DATABASES

Does this have a proc table?

SHOW TABLES FROM mysql

Does the table have any stored procedures

SELECT * FROM mysql.proc

[waqasahmed996]

i do not have full access to system i think that's why database name 'mysql' not displayed with command 'SHOW DATABASES'. i want to ask just one more thing. is that possible that stored procedures are stored other that table 'proc'?