Re: Increment in update

Am Donnerstag, 30. Januar 2003 19:57 schrieb Dan Nelson: > In the last episode (Jan 30), Christian Kohlsch?tter said: > > Actually, you _can_ use ORDER BY with UPDATE. > > > > It works fine, if you do an > > > > update tb_roubr set id=id+1 where id>1 order by id DESC > > > > on your table. > > Only

Re: Upgrading from MySQL 3.23.52 to 3.23.54

Am Montag, 6. Januar 2003 04:45 schrieb Peter Teo: > Good day, > > I have read on http://www.mysql.com about the press releases asking all > 3.23 users to upgrade to the latest stable version. > > How can I do this without uninstalling my current version? I tried to > look for some documentation re

Re: LOCK problem with SELECT table alias

Am Sonntag, 5. Januar 2003 19:29 schrieb Paul DuBois: > At 14:45 +0100 1/5/03, [EMAIL PROTECTED] wrote: > > >Description: > > > > A SELECT statement fails if you have table aliases and use > > table locking with the LOCK command > > This is not a bug. It's documented in the manual that y