Home > Database > Mysql Tutorial > How does the value of the system variable max_allowed_packet affect the results of string-valued functions?

How does the value of the system variable max_allowed_packet affect the results of string-valued functions?

WBOY
Release: 2023-09-08 08:05:02
forward
623 people have browsed it

系统变量 max_allowed_pa​​cket 的值如何影响字符串值函数的结果?

The string-valued function returns NULL if the length of the result is greater than the value of the max_allowed_packet system variable. Actually, max_allowed_packet is a dynamic global variable that can accept integer type values. These values ​​can only be set for sessions. It accepts a minimum value of 1024 and a maximum value of 1073741824. The default value of this system variable is 1048576.

The above is the detailed content of How does the value of the system variable max_allowed_packet affect the results of string-valued functions?. For more information, please follow other related articles on the PHP Chinese website!

source:tutorialspoint.com
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template