Home >Database >Mysql Tutorial >Mysql插入内容过长(Packetforqueryistoolarge)_MySQL

Mysql插入内容过长(Packetforqueryistoolarge)_MySQL

WBOY
WBOYOriginal
2016-06-01 13:04:20940browse

这个以前一直没有碰到过,一次性向Mysql数据库插入内容过长的话会出现这个问题,解决办法就是在Mysql配置文件My.ini中找到[mysqld]选项,

在该选项下找到max_allowed_packet属性值(如果没有就自己加上),该属性值默认大小是1M,你可以根据自身项目需求进行更改。

Statement:
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