Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

What version of MYSQL supports stored procedures?

Quick question - What version of MYSQL supports stored procedures?

Is it any Mysql 5.0? Or there is exact version when they implemented support like - 5.0.1.2... ?

Thanks

like image 565
Kelvin Avatar asked Aug 30 '11 15:08

Kelvin


2 Answers

According to http://dev.mysql.com/doc/refman/5.0/en/news-5-0-0.html, "basic support" for stored procedures was present in 5.0.0.

But you shouldn't use a release so old anyway, you should be using the latest release of a given major version.

like image 128
Bill Karwin Avatar answered Sep 19 '22 01:09

Bill Karwin


Version 5.0.0 and higher supports stored procedures. Check the documentation for more details. You can navigate through the FAQ for each version listed in the documentation.

If you check the Product History in Wikipedia, you will see that stored procedures were introduced in Version 5.0 and can be used in all the higher versions.

like image 43
reggie Avatar answered Sep 20 '22 01:09

reggie