MariaDB [test2]> delimiter //
MariaDB [test2]> create procedure p1() #创建存储过程
    -> begin select * from a;
    -> end //
Query OK, 0 rows affected (0.00 sec)

MariaDB [test2]> call p1()            #调用存储过程
    -> ;
    -> //
+------+
| name |
+------+
|    1 |
|    2 |
|    3 |
|    4 |
+------+
4 rows in set (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

MariaDB [test2]>