Welcome to WebmasterWorld Guest from 22.214.171.124 , register , free tools , login , search , pro membership , help , library , announcements , recent posts , open posts Become a Pro Member
MySQL 5.x Stored Procedures and MySQL5 pnllan msg:1578537 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.
pnllan msg:1578538 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'.
sergeytch msg:1578539 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.
iamlost msg:1578540 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.
pnllan msg:1578541 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.