1、创建:
create procedure procedure_name() select * from table_name
2、调用:
call procedure_name
3、查看:
- 查看过程的内容有三种方法:
- 1.
show create procedure procedure_name;
- 2.
show procedure status like 'procedure_name`;
- 3.
select * from mysql.proc where name='procedure_name';
- 1.
4,删除:
drop procedure procedure_name