On Mon, May 17, 2010 at 5:10 AM, Pierre C <lists@peufeu.com> wrote: > - or use a JOIN delete with a virtual VALUES table > - or fill a temp table with ids and use a JOIN DELETE
What is a virtual VALUES table? Can you give me an example of using a virtual table with selects, joins, and also deletes?
delete from a using (values (1),(2),(5),(8)) b(x) where a.id=b.x