S
S
Stepan2012-09-29 22:45:45
MySQL
Stepan, 2012-09-29 22:45:45

Limit for WHERE IN in MySQL?

I once read somewhere that there is a limit on the input data of the WHERE IN () construct.
Can someone tell me what the limit is?

SELECT * 
FROM  `A` 
WHERE  `id` 
IN (
SELECT id
FROM `B`
WHERE row2 =1
)


Tried to substitute for the test in IN 300 000 id. No mistakes. It is more difficult to check, since such tests create a load on the working project.

Answer the question

In order to leave comments, you need to log in

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question