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)