Database-mysql Stored Procedures

A stored procedure is a collection of SQL statements in which the internal SQL statements are executed logically when the stored procedure is actively invoked.

One: Create a stored procedure

　　

MariaDB [test2]> delimiter//MariaDB [test2]> CREATE PROCEDURE p1 () #创建存储过程     from  A;     -End//Query OK, 0 rows affected (0.00 sec) MariaDB [test2]> Call p1 ()            #调用存储过程    -> ;     //+------+| Name |+------+|    1 | |    2 | |    3 | |     in Set (0.00 sec) Query OK, 0 rows affected (0.00 sec) MariaDB [test2]

Database-mysql Stored Procedures