homepage Welcome to WebmasterWorld Guest from
register, free tools, login, search, pro membership, help, library, announcements, recent posts, open posts,
Become a Pro Member
Home / Forums Index / Code, Content, and Presentation / Databases
Forum Library, Charter, Moderator: open

Databases Forum

MySQL 5.x
Stored Procedures and MySQL5

5+ Year Member

Msg#: 61 posted 4:38 pm on Sep 29, 2005 (gmt 0)

Does anyone know where I can find information on MySQL 5 Stored Procedures other than from MySQL AB?

I could use some good examples on Procedures and Functions, as I would like to employ these new features in MySQL 5 to my dynamic web pages.




5+ Year Member

Msg#: 61 posted 5:58 pm on Sep 30, 2005 (gmt 0)

I guess nobody here has tried implementing MySQL 5 Stored Procedures and Stored Functions.

Either that or the 'cat has gotten everyone's tongue'.


5+ Year Member

Msg#: 61 posted 5:51 pm on Oct 2, 2005 (gmt 0)

I can only give a link to the MySQL AB article on that:
in brief - [dev.mysql.com...]
and the full version - [dev.mysql.com...]

but it's really interesting why there's no other sources of information on that question :-\ so, i'll try to find something more.


WebmasterWorld Senior Member 10+ Year Member

Msg#: 61 posted 7:24 pm on Oct 2, 2005 (gmt 0)

The reasons you see little about MySQL 5.0 Stored Procedures and Functions are:
* they are new features to MySQL so it is not surprising that most references are still the developers.
* people previously requiring such features from Open Source already use PostgreSQL which has incorporated such features for years.

You might want to search for Postgre and Oracle code examples. Most SQL is similar if not exactly the same.


5+ Year Member

Msg#: 61 posted 1:33 am on Oct 3, 2005 (gmt 0)

Yes, I had seen MySQL AB's documentation. I was hoping to start some dialog with others to see what others think.

Most SQL and other languages bare similiarities, some more than others. Most of my SQL experience in MS SQL and Oracle and I'm just trying soaking up some more. I'll give PostgreSQL a look.


Global Options:
 top home search open messages active posts  

Home / Forums Index / Code, Content, and Presentation / Databases
rss feed

All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
Home ¦ Free Tools ¦ Terms of Service ¦ Privacy Policy ¦ Report Problem ¦ About ¦ Library ¦ Newsletter
WebmasterWorld is a Developer Shed Community owned by Jim Boykin.
© Webmaster World 1996-2014 all rights reserved