Difference between DELETE and DELETE FROM statement
From: Ninjali <nickli2000_at_gmail.com>
Date: Sun, 2 Aug 2009 08:48:57 -0700 (PDT)
Message-ID: <7c6e2c4e-ef5e-4e6b-8ac6-0d7e69552160_at_d23g2000vbm.googlegroups.com>
Hi,
Date: Sun, 2 Aug 2009 08:48:57 -0700 (PDT)
Message-ID: <7c6e2c4e-ef5e-4e6b-8ac6-0d7e69552160_at_d23g2000vbm.googlegroups.com>
Hi,
Are there any differences between DELETE and DELETE FROM statements? Can they be used interchangably? For example"
delete from mytable where ....;
delete mytable where ....;
Thanks in advance.
Nick Li Received on Sun Aug 02 2009 - 10:48:57 CDT