Re: Difference between DELETE and DELETE FROM statement

From: David Portas <REMOVE_BEFORE_REPLYING_dportas_at_acm.org>
Date: Tue, 4 Aug 2009 14:08:03 -0700 (PDT)
Message-ID: <713f23da-f5c9-4014-b1cb-1df5d0c67cc9_at_k1g2000yqf.googlegroups.com>

On 3 Aug, 14:34, Ninjali <nickli2..._at_gmail.com> wrote:
> On Aug 3, 12:22 am, kevin <majun..._at_hotmail.com> wrote:
>
>
>
> > Answer is: they are interchangably, you can delete rows with any of it.
>
>
> Thanks for your help.
>
> Now I can save some typing.
>

Or you could write standard SQL which is DELETE FROM tbl, not DELETE tbl.

--
David Portas

Received on Tue Aug 04 2009 - 16:08:03 CDT