Re: Re: join question
| From: | Christoph Becker | Date: | Sun, 13 Apr 2014 19:39:37 +0000 |
| Subject: | Re: Re: join question | ||
| References: | 1 2 3 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-323193@lists.php.net to get a copy of this message | ||
richard gray wrote:
> On 13/04/2014 20:46, Christoph Becker wrote:
>>
>> There are no JOIN clauses allowed in UPDATE statements.[1]
>>
>> On a quick glance it seems to me that your database could need some
>> normalization. The database mailing list[2] might be a more appropriate
>> place to discuss this topic.
>>
>> [1] <iEÖ§<€rlru÷
>> xA"Ÿhttp://dev.mysql.com/doc/refman/5.7/en/update.html>
>> [2] <mailto:php-db@lists.php.net>
> er.. you *can* use a join clause in an update statement ...
>
>
> http://stackoverflow.com/questions/15209414/mysql-update-join/15209489#15209489 5ѶR_¢]¢ŽdvAŸÃ
>
Oh, I was not aware of that. Thanks for pointing it out.
--
Christoph M. Becker