Hi All,
I need to let the values in two columns change place with each other.
I've tried to "update xxx set a=b, b=a" but that doesn't work (b=a uses
the "new" a).
sql,query
/Jorgen
---------------------------------------------------------------------
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
- Update Question Clarence Kwei
- Re: Update Question Benjamin Pflugmann
- Re: Update Question Bob Hall
- update question Rus
- Update Question Marcelo
- Update question Jeff Tanner
- re: update question Jörgen Winqvist
- re: update question Egor Egorov
- RE: update question Anderson, Alan R
- update question chip wiegand
- Re: update question Tore Bostrup
- Re: update question chip wiegand
- Re: update question Tore Bostrup
- Re: update question chip wiegand
- Update question jaydrake
- Re: Update question Paul DuBois
- InnoDB Foreign Key Constraint Issue David Griffiths