Welcome to WebmasterWorld Guest from 54.156.36.82

Forum Moderators: open

Message Too Old, No Replies

MySQL 5.x

Stored Procedures and MySQL5

     
4:38 pm on Sep 29, 2005 (gmt 0)

New User

10+ Year Member

joined:Aug 29, 2005
posts:8
votes: 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.

Thanks

5:58 pm on Sept 30, 2005 (gmt 0)

New User

10+ Year Member

joined:Aug 29, 2005
posts:8
votes: 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:51 pm on Oct 2, 2005 (gmt 0)

New User

10+ Year Member

joined:Oct 2, 2005
posts:4
votes: 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.

7:24 pm on Oct 2, 2005 (gmt 0)

Senior Member from CA 

WebmasterWorld Senior Member 10+ Year Member Top Contributors Of The Month

joined:Nov 25, 2003
posts:1047
votes: 219


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.

1:33 am on Oct 3, 2005 (gmt 0)

New User

10+ Year Member

joined:Aug 29, 2005
posts:8
votes: 0


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

iamlost,
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.

Thanks