Welcome to WebmasterWorld Guest from 54.146.180.94

Forum Moderators: open

MySQL 5.x

Stored Procedures and MySQL5

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

5+ Year Member



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 Sep 30, 2005 (gmt 0)

5+ Year Member



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)

5+ Year Member



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)

WebmasterWorld Senior Member 10+ Year Member



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)

5+ Year Member



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

 

Featured Threads

Hot Threads This Week

Hot Threads This Month