Stored Procedures allow you to write and call full SQL Statements just like scripts in an operating system.
delimiter $$ create procedure procedureName() begin select * from table; end$$ delimiter ;
- delimiter $$ or delimiter ; – sets delimiter
- call procedureName; – calls procedure
- show procedure status where db=’databaseName’; – shows procedures in database
- show create procedure procedureName; – shows how procedure was created
- drop procedure procedureName; – deletes procedure