| List: | General Discussion | « Previous MessageNext Message » | |
| From: | Perrin Harkins | Date: | May 27 2009 12:02pm |
| Subject: | Re: Should I be able to DELETE FROM ... WHERE .. IN ( ... ) with multiple a column key? | ||
| View as plain text | |||
On Wed, May 27, 2009 at 6:43 AM, Simon J Mudd <sjmudd@stripped> wrote: > So is the format of the DELETE FROM .. WHERE ... IN ( ... ) clause I > propose valid and SHOULD the optimiser recognise this and be expected > to just find the 2 rows by searching on the primary key? Not according to the docs: http://dev.mysql.com/doc/refman/5.1/en/comparison-operators.html#function_in - Perrin
| Thread | ||
|---|---|---|
| • Should I be able to DELETE FROM ... WHERE .. IN ( ... ) with multiple a column key? | Simon J Mudd | 27 May |
| • Re: Should I be able to DELETE FROM ... WHERE .. IN ( ... ) with multiple a column key? | Perrin Harkins | 27 May |
| • Re: Should I be able to DELETE FROM ... WHERE .. IN ( ... ) with multiple a column key? | Simon J Mudd | 27 May |
| • Re: Should I be able to DELETE FROM ... WHERE .. IN ( ... ) with multiple a column key? | Baron Schwartz | 27 May |
| • Re: Should I be able to DELETE FROM ... WHERE .. IN ( ... ) with multiple a column key? | Moon's Father | 31 May |