Re: Subquery trouble :)
| From: | Hans Spaans | Date: | Tue, 13 May 2003 21:52:40 +0000 |
| Subject: | Re: Subquery trouble :) | ||
| References: | 1 2 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-27729@lists.php.net to get a copy of this message | ||
On Tue, May 13, 2003 at 11:40:24PM +0200, Andreas Cahen wrote:
> Hi Maxim!
>
> > 3 questions:
>
> > 1. what DB is it for? Looks like Oralce to me :)
> > 2. What sense can it make updating town_id to 910 on any row that
> already contains it? 3. what is this 'Domain'? That could actually be
> your syntax error.
>
> So far... 2 questions :)
>
> 1. I use mySQL, such subqueries were working the days I used to work
> with Oracle, but those days are gone now :)
If I'm not mistaken, MySQL started supporting subselects in version
4.0 or 4.1.
--
Hans