Function and Procedure instance usage in MySQL5.0
This article mainly introduces "the usage of Function and Procedure examples in MySQL5.0". In the daily operation, I believe that many people have doubts about the usage of Function and Procedure examples in MySQL5.0. The editor consulted all kinds of materials and sorted out simple and easy-to-use operation methods. I hope it will be helpful to answer the doubts about the usage of Function and Procedure examples in MySQL5.0. Next, please follow the editor to study!
Create function (Function)
Create:
Mysql > CREATE FUNCTION MyFunc (s CHAR (20)) RETURNS CHAR (50) RETURN CONCAT
('Hello',s,'.Lan','!')
Use:
Mysql > select MyFunc ('Dennis')
Delete:
Drop function MyFunc
Create a stored procedure (Procedure)
Create:
(because the stored procedure ends with ";", and ";" ends with mysql's default sql. So you have to change the Terminator of mysql first.
Mysql > delimiter |
Mysql > CREATE PROCEDURE MyProc (OUT param1 INT) BEGIN SELECT COUNT (*) INTO
Param1 FROM mysql.user; END
-> |
Official document: http://www.mysql.com/doc/en/CREATE_PROCEDURE.html
Call:
Step one:
Mysql > CALL MyProc (@ a) |
Step 2:
Mysql > select @ a
-> |
A complete example:
Mysql > CREATE PROCEDURE MyProc (OUT param1 INT) BEGIN SELECT COUNT (*) INTO
Param
1 FROM mysql.user; END
-> |
Query OK, 0 rows affected (0.00 sec)
Mysql > call MyProc (@ a) |
Query OK, 0 rows affected (0.03 sec)
Mysql > select @ a |
+-+
| | @ a |
+-+
| | 4 |
+-+
1 row in set (0.00 sec)
Delete:
Mysql > drop procedure MyProc |
(note that the name of the stored procedure here is case sensitive.)
Note: if you appear when connecting to the program:
Client does not support authentication protocol requested by server; consider upgrading
MySQL client
[@ more@]
At this point, the study on "the usage of Function and Procedure examples in MySQL5.0" is over. I hope to be able to solve your doubts. The collocation of theory and practice can better help you learn, go and try it! If you want to continue to learn more related knowledge, please continue to follow the website, the editor will continue to work hard to bring you more practical articles!
