Solved

Does MySQL V.5.0.95 support stored procedures

Posted on 2013-06-28
3
657 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
Comment Utility
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
Comment Utility
How do I upgrade the version running on under CentOS 5 ?
0
 
LVL 48

Assisted Solution

by:PortletPaul
PortletPaul earned 250 total points
Comment Utility
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

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

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.
Creating and Managing Databases with phpMyAdmin in cPanel.
Connecting to an Amazon Linux EC2 Instance from Windows Using PuTTY.
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.

762 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

Need Help in Real-Time?

Connect with top rated Experts

8 Experts available now in Live!

Get 1:1 Help Now