The characteristics and example usage of mysql stored procedure

This article introduces the knowledge of "the characteristics of mysql stored procedures and the usage of examples". Many people will encounter this dilemma in the operation of actual cases, so let the editor lead you to learn how to deal with these situations. I hope you can read it carefully and be able to achieve something!

Features:

1. Enhance the function and flexibility of SQL language. Can be written with flow control statements, strong flexibility, complete complex judgments and complex operations.

2. Improve the reusability and standard of SQL.

3. Reduce the number of compiling, execute quickly and improve efficiency.

Example

Mysql > DELIMITER / / mysql > CREATE PROCEDURE proc1 (OUT s int)-> BEGIN-> SELECT COUNT (*) INTO s FROM user;-> END-> / / mysql > DELIMITER; this is the end of the introduction of "characteristics and example usage of mysql stored procedures". Thank you for reading. If you want to know more about the industry, you can follow the website, the editor will output more high-quality practical articles for you!