Jeremy Stephens writes: > Why is the UPDATE syntax so different from INSERT? If I'm > constructing a SQL statement to insert or update based on the > existence of a row in some code, I have to have two completely > different cases to handle it. What were the SQL creators thinking?
I've always been a particular un-fan of the way that `DELETE FROM table_name` is a proper prefix of `DELETE FROM table_name WHERE expression` (and similarly for `UPDATE`). -- Aaron Crane