Mysql 简单的存储过程

简单的存储过程举例:

mysql> delimiter //

mysql> create proc li
    -> begin
    ->  selecte * from te1;
    -> end
    -> //

mysql> delimiter ;

mysql> call li(2);

+------+
| name |
+------+
| har  |
| lks  |
+------+
2 rows in set (0.00 sec)




 li(1);