ストアドプロシジャ

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)