The simplest example: mysql> DELIMITER $$ mysql> USE test $$ Database changed mysql> DROP PROCEDURE IF EXISTS `sp_add`$$ Query OK, 0 rows affected (0.00 sec) mysql> CREATE PROCEDURE sp_add(a INT, b INT,OUT c INT) -> BEGIN &nb
1. MySQL stored procedure with in and out parameters and a small example of how to call PHP and PB
Introduction: How to call MySQL's stored procedure in PHP? I have not tested it. I have borrowed examples from friends, as follows:
## 2. Method to automatically identify and convert text encoding in PHP
Introduction: When PHP processes pages, we use iconv to convert character sets Or functions such as mb_convert, but this actually has a premise. That is, we must know in advance what encoding in and out are so that we can perform the correct conversion. Although most conversions are between gbk and utf-8, what if you don't know the encoding of the conversion object? Google has come up with such a function safeEncoding, which can easily identify the encoding of UTF8 and GBK. This function is very accurate to a certain extent, but in
3. Oracle subroutine parameter mode, IN, OUT, NOCOPY
Introduction: Oracle subroutine parameter modes mainly include IN, OUT, NOCOPY. IN and OUT can be combined, and OUT and NOCOPY can also be used in combination.
##4. Introduction: Welcome to the network technology community forum, interact with 2 million technical personnel>>In and out are relative, such as: A (s0) - (s0) B (s1) - (s1) C Assume that you now want to deny A access to C, and assume that you are required to do ACL on B (of course it can also be done on C), let's change this topology As an example: B's s0 port is the front door, and s1 port is5. Introduction: Welcome Enter the network technology community forum and interact with 2 million technical staff> Enter in and out are relative, such as: A (s0) - (s0) B (s1) - (s1) C Suppose you want to now Deny A access to C, and assuming that you are required to do ACL on B (of course it can also be done on C), let's change this topology into an example: B's s0 port is the front door, and s1 port is
6.
MySQL stored procedure with in and out parameters
Introduction: Welcome to the Linux community forum and interact with 2 million technical staff>> ;The simplest example of entering a MySQL stored procedure with in and out parameters: [html] mysql DELIMITER $$ mysql USE test $$ Database changed mysql DROP PROCEDURE IF EXISTS `sp_add`$$ Query OK, 0 rows affected (0.00 sec) mysq7.
MySQL stored procedure with in and out parameters_MySQL
Introduction: MySQL stored procedure with in and out parameters out parameter8.
Method to create a stored procedure with IN and OUT parameters in MySQL_MySQL
Introduction: This article mainly introduces the method of creating stored procedures with IN and OUT parameters in MySQL, which simplifies the operation to a certain extent. Friends in need can refer to it[Related Q&A recommendations]:
linux - How to use tcpdump to view in and out data on a certain port at the same timelinux - kernel kfifo The problem of in and out in .c [resolved]
The above is the detailed content of Summarize the points to note about in and out. For more information, please follow other related articles on the PHP Chinese website!