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,

  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

Original text of this message