MySQL IN条件限制 [英] MySQL IN condition limit

问题描述

嘿，我必须在具有大量ID的MySQL语句中使用IN条件.

Hey, I have to use IN condition in my MySQL statement with a large set of ids.

示例

SELECT * FROM users WHERE id IN (1,2,3,4...100000)

IN语句可以包含的项是否有限制?

Is there a limit if items the IN statement can have?

推荐答案

没有，请检查

IN列表中的值数仅受

The number of values in the IN list is only limited by the max_allowed_packet value.

这篇关于MySQL IN条件限制的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！