mysql ストアドプロシージャ stored procedure

定義

mysql> delimiter //
mysql> create procedure hoge()
-> select curdate();
Query OK, 0 rows affected (0.00 sec)

呼び出し

mysql> call hoge();

作成済み一覧

mysql> show procedure status;

詳細

mysql> show create procedure hoge;

削除

mysql> drop procedure hoge;

select 文

mysql> create procedure fuga()
begin
select * from users;
end//

while

mysql> create procedure foo()
-> begin
-> declare cnt int;
-> set cnt = 0;
-> while cnt < 10 do
-> select * from users;
-> set cnt = cnt + 1;
-> end while;
-> end
-> //
Query OK, 0 rows affected (0.01 sec)