MySQL - Stored Procedures Introduction

MySQL - Stored Procedures Introduction

Find code and diagrams at: https://ift.tt/2zY82iQ 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

View on YouTube