MySQL 5.x

Stored Procedures and MySQL5

[pnllan]

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

[pnllan]

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

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

[sergeytch]

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.

[iamlost]

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.

[pnllan]

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