Re: Variable number of arguments

[Peter Brawley]

No, MySQL sprocs accept only a fixed number of arguments. ISO SQL is somewhat optimised for correct RDBMS logic (unless you were to ask EF Codd, CJ Date or Fabian Pascal), but in many ways SQL is quite literal, so if SQL seems to make what you are trying to do very difficult, it could be that your design needs another look, in this case aspects of the design that require repeated multiple ad hoc deletions.

If such deletions are unavoidable, here are three options. First, in an application language build the delete query to include comma-delimited string of IDs. Second, pass such a string to an sproc that PREPAREs the query using such a string. Third, populate a temp table with the target IDs and write a simple join query that deletes the joined IDs.

PB