首页 笔记 图片 查字 
所属分类:MySQL
浏览:109
内容:

MySql中in语句中参数个数是不限制的,但是受到SQL语句长度的现在。

整段SQL语句的长度有默认限制4MB,系统配置参数 max_allowed_packet,SQL语句最大1G。


参考:

https://dev.mysql.com/doc/refman/5.7/en/comparison-operators.html#operator_in

https://dev.mysql.com/doc/refman/5.7/en/server-system-variables.html#sysvar_max_allowed_packet

https://www.cnblogs.com/daleyzou/p/inWithMysql.html

https://blog.csdn.net/u012337114/article/details/79157870

https://blog.csdn.net/LJFPHP/article/details/103656726