Hi

  I would like to know , How to write Procedures in Mysql similar to Pl/Sql , and also whether it is similar to pl/sql or not?

Thank You.

Praveen:(

Hi

The procedures and functions in MySQL 5.0 are seemingly similar to PL/SQL , but this is a alpha version and doesn't work well,The mysql documentation is also poor.

CREATE PROCEDURE simpleproc (OUT param1 INT)
  BEGIN
     SELECT COUNT(*) INTO param1 FROM t;
   END;


This is the only documentation that I have obtained.
http://www.mysql.com/doc/en/CREATE_PROCEDURE.html

Best Regards,

Peter Tesone
Mentat Technologies
http://www.mentattech.com