Новости IT

[• smoyla]

Работаю с болльшим объемом базы SQL вылезла ошибка для запросов. Как исправить кто знает?
sql> \W
Shоw wаrnings еnаblеd.
mysql> SELECT REPЕАT('А', 1ОООООО);
+-----------------------+
| REPEAT('A', 1ОООООО) |
+-----------------------+
| NULL |
+-----------------------+
1 rоw in sеt, 1 wаrning (0.00 sеc)

Warning (Code 1301): Result of repeat() was larger than max_allowed_packet (1048576) - truncated

[• Snowm@n]

Отсюда

Change in the my.ini or ~/.my.cnf file by including the single line under [mysqld] section in your file:

max_allowed_packet=500M
then restart the MySQL service and you are done.

See the documentation for further information.

--------------------

Developer -> Lead Developer -> Lead Architect -> ... ?