Solved

Does MySQL V.5.0.95 support stored procedures

Posted on 2013-06-28
3
683 Views
Last Modified: 2013-07-07
Hi,

We Require stored procedures. Does our verion (MySQL version 5.0.95) support stored procedures? If not how can we go about upgrading it?....With that in mind - to which verion would you recommend we utilise in terms of stability of its version? We also have MySQL running under CENTMOS Version 5.1

TX
0
Comment
Question by:shaunwingin
3 Comments
 
LVL 9

Accepted Solution

by:
TvMpt earned 250 total points
ID: 39283828
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.


  Version 5.0: beta from March 2005, production release October 2005 (cursors, stored procedures, triggers, views, XA transactions)
0
 

Author Comment

by:shaunwingin
ID: 39288449
How do I upgrade the version running on under CentOS 5 ?
0
 
LVL 48

Assisted Solution

by:PortletPaul
PortletPaul earned 250 total points
ID: 39299231
Not familiar with your specific combination of MySQL/CentOS, the O/S version is old too.

If your O/S is that old your hardware might be also.

see:
http://en.wikipedia.org/wiki/CentOS 5.1 2007-12-02
https://en.wikipedia.org/wiki/MySQL 

End of Product Lifecycle.
Active development for MySQL Database Server version 5.0 has ended. Oracle offers various support offerings which may be of interest. For details and more information, see the MySQL section of the Lifetime Support Policy for Oracle Technology Products (http://www.oracle.com/us/support/lifetime-support/index.html). Please consider upgrading to a recent version.
http://dev.mysql.com/doc/relnotes/mysql/5.0/en/

General documentation on installation and upgrades for MySQL are freely available, e.g.
http://dev.mysql.com/doc/refman/5.7/en/installing.html (depending on what version you upgrade to)

I suggest you have some thinking/planning to do - sorry can't offer much more than this.
0

Featured Post

NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

CCModeler offers a way to enter basic information like entities, attributes and relationships and export them as yEd or erviz diagram. It also can import existing Access or SQL Server tables with relationships.
Fine Tune your automatic Updates for Ubuntu / Debian
Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

680 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question