List:General Discussion« Previous MessageNext Message »
From:Thimble Smith Date:March 18 1999 11:53pm
Subject:Re: Can Mysql use JOIN in UPDATE statements?
View as plain text  
On Thu, Mar 18, 1999 at 05:31:32PM -0600, Brandon Shuey wrote:
> If what is the format?

Nope.  Update works on a single table (it's SQL).  For now you
can do something like:

    INSERT INTO temporary_table SELECT <your choice, using joins>;
    DELETE FROM original_table WHERE ...;
    INSERT INTO temporary_table SELECT * from temporary_table;
    DROP TABLE temporary_table;

Tim
Thread
Can Mysql use JOIN in UPDATE statements?(Brandon Shuey)19 Mar
  • Re: Can Mysql use JOIN in UPDATE statements?Thimble Smith19 Mar
    • Re: Can Mysql use JOIN in UPDATE statements?Thimble Smith19 Mar
  • mysqlimport does not keep case of filenameMichael Widenius15 Nov