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 and reloading it from the file --- which would work except the fact that the file must not exist, as said by the doc), I could not find anything else than using some php script to do the job, row by row. If someone has an idea (waiting for MySQL 4.1 !?), it will be welcomed. Étienne --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php