Mysql创建和删除存储过程
mysql> delimiter $$
mysql> create procedure test(in content varchar(20),in description varchar(20))
-> begin
-> select *,description from course_type where course_type_name like concat('%',content,'%');
-> end$$
Query OK, 0 rows affected (0.00 sec)
mysql> delimiter ;
mysql> call test('a','这是存储过程的描述');
+----------------+------------------+--------------------+
| course_type_id | course_type_name | description |
+----------------+------------------+--------------------+
| 6 | APP | 这是存储过程的描述 |
+----------------+------------------+--------------------+
1 row in set (0.00 sec)
Query OK, 0 rows affected (0.00 sec)
mysql> drop procedure test;
Query OK, 0 rows affected (0.00 sec)
mysql> call test('a','这是存储过程的描述');
ERROR 1305 (42000): PROCEDURE work.test does not exist