MySQL Learning notes (16) Stored procedures

(Stored procedure: (ForSQL programming, just know)

1, stored procedures: similar to a function, is to encapsulate a piece of code. When you want to execute this piece of code, you can do so by calling the stored procedure. In the body of the statement in the package , you can use if/else, Case, while and so on to control the structure, SQL programming.

2. View stored procedures:

Show procedure status;

3. Delete:

Drop procedure process name;

4. Call:

Call process name ();

5.in MySQL , the difference between stored procedures and functions:

1. different names.

2. The stored procedure does not return a value.

This article is from the "Learning and Exchange" blog, please be sure to keep this source http://chenhaolinux.blog.51cto.com/9609922/1710815

MySQL Learning notes (16) Stored procedures