I assumed there would be as well, but when I looked it up, that's what the docs for MySQL 5 said. Specifically, I dug around until I found the limit on the IN clause. It said it was limited by max_allowed_packet, which I then looked up.
Hence, "according to the docs". --Ben Doom Dave Watts wrote: >> Which, according to the docs, is only limited by max_allowed_packet. >> The default is 1Mb, but it can be set arbitrarily up to the >> size of available RAM if that becomes a problem. > > Databases generally have some limit on the number of items within an IN > clause, which is completely separate from the maximum size of text used for > an SQL query. > > Dave Watts, CTO, Fig Leaf Software > http://www.figleaf.com/ > > Fig Leaf Software provides the highest caliber vendor-authorized > instruction at our training centers in Washington DC, Atlanta, > Chicago, Baltimore, Northern Virginia, or on-site at your location. > Visit http://training.figleaf.com/ for more information! > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Download the latest ColdFusion 8 utilities including Report Builder, plug-ins for Eclipse and Dreamweaver updates. http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:291766 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
