Where stored procedures stored in MySQL
2024-04-25 03:53:26
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.
- MySQL WHERE, AND & OR syntax
- MySQL where date last 7 days
- MySQL Query where DateTime is greater than today
- What is the first number assigned to AUTO_INCREMENT?
- Maximum value of AUTO_INCREMENT in Mysql
- Connect to MySQL from the command line
- What is the initial value of a local variable in a stored procedure in Mysql?
- Is it possible to perform an outer join between temporary tables?
- fjdskjfkd
- Online Aptitude Test for Freshers | MeritTrac
Laravel interview Questions © 2019 - Designed by PSD to HTML