Etienne,
Wednesday, October 30, 2002, 1:51:32 PM, you wrote:
ED> I would like to know if MySQL allows some way to do
ED> "UPDATE SomeTable SET SomeColumn=(SELECT SomeExpression FROM SomeTable,
ED> SomeOtherTable WHERE SomeTable.ForeignKey=SomeOtherTable.PrimaryKey);"
ED> Although I had some idea
Greetings,
I would like to know if MySQL allows some way to do
"UPDATE SomeTable SET SomeColumn=(SELECT SomeExpression FROM SomeTable,
SomeOtherTable WHERE SomeTable.ForeignKey=SomeOtherTable.PrimaryKey);"
Although I had some ideas (like sending SELECT result to a file, deleting
table SomeTable
