Find code and diagrams at: https://www.EliTheComputerGuy.com
Stored Procedures allow you to write and call full SQL Statements just like scripts in an operating system.
Create Procedure:
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
