GMgKe586q6suSQnyqZLlGCooeWM

Pages

Search

Friday, March 18, 2011

MySQL - Stored Procedure

Look directly to this example:
mysql> DELIMITER //
mysql> CREATE PROCEDURE p()
       BEGIN
           SELECT * FROM data;
       END //
mysql> DELIMITER //
mysql> CALL p()

Other example
mysql> CREATE PROCEDURE p(a INT)
       BEGIN
           SELECT * FROM data WHERE id = a;
       END //

mysql> CREATE PROCEDURE p(a INT)
       BEGIN
           SET @add = 1;
           SELECT * FROM data WHERE id = @add + a;
       END //
Share/Bookmark

1 comment: