你是如何插入的? 估计是max_allowed_packet没设置对吧。mysql> show variables like '%pack%'; +--------------------+---------+ | Variable_name | Value | +--------------------+---------+ | max_allowed_packet | 1048576 | +--------------------+---------+ 1 row in set (0.00 sec)mysql>
估计是max_allowed_packet没设置对吧。mysql> show variables like '%pack%';
+--------------------+---------+
| Variable_name | Value |
+--------------------+---------+
| max_allowed_packet | 1048576 |
+--------------------+---------+
1 row in set (0.00 sec)mysql>
我是这样用的:$iid = trim($iid);
$content = trim($content);
$sql = "insert into item_content (iid,content) values ('$iid','$content')";
mysql_query($sql);
你回答我的根本风马牛不相及。
我打开my.ini
中发现两个max_allowed_packet 我两个都设置了
------------------------------
# The MySQL server
[mysqld]
port = 3306
socket = /tmp/mysql.sock
skip-locking
key_buffer = 16M
max_allowed_packet = 32M
table_cache = 256
sort_buffer_size = 512K
net_buffer_length = 8K
read_buffer_size = 256K
read_rnd_buffer_size = 512K
myisam_sort_buffer_size = 32Mmax_connections = 1000
default-storage-engine = MYISAM
skip-innodb
-----------------------------------------
[mysqldump]
quick
max_allowed_packet = 64M[mysql]
no-auto-rehash
# Remove the next comment character if you are not familiar with SQL
#safe-updates[isamchk]
key_buffer = 20M
sort_buffer_size = 20M
read_buffer = 2M
write_buffer = 2M[myisamchk]
key_buffer = 20M
sort_buffer_size = 32M
read_buffer = 2M
write_buffer = 2M[mysqlhotcopy]
interactive-timeout