Create & Drop Stored Procedure in MySql
HOW TO CREATE MySQL STORED PROCEDURE:
1. Delimiters can be used when you need to define the stored procedures,
function as well as to create triggers. The default delimiter is semicolon.
2. You can change the delimiters to create procedures and so on.
However, but if you are considering multiple statements,
then you need to use different delimiters like $$ or //.
3. The first and last DELIMITER commands are not a part of the stored procedure.
The first DELIMITER command changes the default delimiter to //
and the last DELIMITER command changes the delimiter back to the default one which is semicolon (;).
4. To create a new stored procedure, you use the CREATE PROCEDURE statement.
SYNTAX:
CREATE PROCEDURE procedure_name(parameter_list)
BEGIN
statements;
END //
Advantages:
Increasing the performance of applications
Reusable and transparent
Fast
--------------------------
Disadvantages:
Memory usage increased
Restricted for complex business logic
Difficult to debug
-------------------------------------------
Please share & subscribe!!!
-------------------------------------------
Watch video Create & Drop Stored Procedure in MySql online without registration, duration hours minute second in high quality. This video was added by user VDS Tech Labs 27 July 2020, don't forget to share it with your friends and acquaintances, it has been viewed on our site 708 once and liked it 5 people.