- Before enter a stored procedure you must change the delimiter for the instruction this way (for example):
Delimiter $
- SHOW PROCEDURE STATUS will show you all the existing stored procedures
- SHOW CREATE PROCEDURE procedure_name will show you the content of the procedure_name procedure
- CALL procedure_name to call the procedure called procedure_name
- In order to modify a stored procedure you before need to cancel and re-create it.
