ストアドプロシジャ
mysql> delimiter // mysql> CREATE PROCEDURE sp_1() -> SELECT * FROM t_tokui; -> // Query OK, 0 rows affected (0.08 sec) mysql> CALL sp_1() // +------+-----------+ | tkcd | tkname | +------+-----------+ | 1001 | 得意先名1 | | 1002 | 得意先名2 | | 1003 | 得意先名3 | | 1004 | 得意先名4 | | 1005 | 得意先名5 | +------+-----------+ 5 rows in set (0.00 sec) Query OK, 0 rows affected (0.22 sec)