Search code examples
mysqldelete-row

Mysql multiple delete or rows in one statement. Is there a limit?

I'm using a statement like this with PHP/Mysql:

DELETE FROM `site1` . `users` WHERE `email` IN ('[email protected]', '[email protected]', '[email protected]')

I may have a few hundred or a thounsand at a time, will this be a problem for MySql to handle? Is there a limit to the array used for the "IN" function?

thanks

Solution

  • According to the documentation, there is no specific limit on the number of arguments to IN:

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