What's the max number of characters I can store in a JSON column in MySQL? I don't see this mentioned in the MySQL manual.
解决方案
Here's a demo of what @JorgeLondoño is talking about.
Set the server's max allowed packet size:
mysql> set global max_allowed_packet=1024*1024*1024;
Exit and open the mysql client again, this time setting the client max packet size to match:
$ mysql --max-allowed-packet=$((1024*1024*1024*))
Create a test table with a JSON column and fill it with the longest JSON document you can:
mysql> create table test.jtest ( j json );
mysql> insert into test.jtest
set j = concat('[', repeat('"word",', 100000000), '"word"