3 messages in com.mysql.lists.mysqlRe: Can Mysql use JOIN in UPDATE stat...
FromSent OnAttachments
Brandon Shuey18 Mar 1999 15:31 
Thimble Smith18 Mar 1999 15:53 
Thimble Smith18 Mar 1999 15:55 
Subject:Re: Can Mysql use JOIN in UPDATE statements?
From:Thimble Smith (ti@desert.net)
Date:03/18/1999 03:53:05 PM
List:com.mysql.lists.mysql

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