[GENERAL] Why doesn't update syntax match insert syntax?

I've been curious about this for a long time. The syntax for an INSERT query is often much easier to use, in my opinion, then the syntax for an UPDATE query. For example, and this is what I am trying to do, assume you have a table of inner covers containing a name field and fields named x and

Re: [GENERAL] Why doesn't update syntax match insert syntax?

On Thu, Oct 10, 2013 at 10:03 AM, Rob Richardson rdrichard...@rad-con.com wrote: I've been curious about this for a long time. The syntax for an INSERT query is often much easier to use, in my opinion, then the syntax for an UPDATE query. For example, and this is what I am trying to do,

Re: [GENERAL] Why doesn't update syntax match insert syntax?

On Thu, Oct 10, 2013 at 10:03 AM, Rob Richardson rdrichard...@rad-con.com wrote: UPDATE inner_covers SET X = (SELECT sl.X FROM storage_locations sl where sl.name = inner_covers.name), Y = (SELECT sl.Y FROM storage_locations sl where sl.name = inner_covers.name) Or is there