View Single Post

  #5 (permalink)  
Old 05-16-2008
André Hänsel
 
Posts: n/a
Default Re: Alias of scalar subquery

On May 9, 3:33 pm, Rik Wasmus <luiheidsgoe...@hotmail.com> wrote:
> Tested in MySQL 5.0.45, it works here, I don't really feel like
> installing earlier versions to check wether those work too. Just try it :).


You're absolutly right, that has been working all along. Damn, I
always thought, I could not UPDATE and SELECT from the same table.
Reply With Quote