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!!!
-------------------------------------------
Смотрите видео Create & Drop Stored Procedure in MySql онлайн без регистрации, длительностью часов минут секунд в хорошем качестве. Это видео добавил пользователь VDS Tech Labs 27 Июль 2020, не забудьте поделиться им ссылкой с друзьями и знакомыми, на нашем сайте его посмотрели 708 раз и оно понравилось 5 людям.