Where stored procedures stored in MySQL

2019-12-09 23:51:05 Ravi Mysql

In MySQL Stored procedures are supported after release of MySQL version 5.0. Stored procedures are set of SQL statements that are stored on server. So question is actually where or on which location mysql compiled procedures are stored?

Mysql stores stored procedures in proc table of database. The physical location of Stored procedures on server be <datadir>/mysql/proc.MYI and <datadir>/mysql/proc.MYD. 

This post is submitted by one of our members. You may submit a new post here.

Related Tricks