On Tue, Jul 06, 2010 at 08:08:40PM +0000, Mark wrote:
> I have a unique column, and need two rows to swap their values.
> Is there a way to make the 2 updates at the same time or do I
Can you do that with pure SQL?
> have to update one of them to an unused value in the DB then
> make the swap?
Yes, I think this is the way to go.
Oleg.
--
Oleg Broytman http://phd.pp.ru/ [email protected]
Programmers don't die, they just GOSUB without RETURN.
------------------------------------------------------------------------------
This SF.net email is sponsored by Sprint
What will you do first with EVO, the first 4G phone?
Visit sprint.com/first -- http://p.sf.net/sfu/sprint-com-first
_______________________________________________
sqlobject-discuss mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss
