2011/12/11 Michael Bayer mike...@zzzcomputing.com
My impression was Postgresql handles this much more nicely which is
confirmed by this post:
http://beerpla.net/2009/02/17/swapping-column-values-in-mysql/
the usual way this kind of thing is done is via declaring local variables
in the SQL
Hi, All.
I have found unexpected behaviour of MySQL DB. In update command order of
operations in set list is significant. I need to switch values of 2 rows.
Better see example:
mysql create temporary table sw_test (a integer not null, b integer not
null, dummy integer);
Query OK, 0 rows affected
My impression was Postgresql handles this much more nicely which is confirmed
by this post:
http://beerpla.net/2009/02/17/swapping-column-values-in-mysql/
the usual way this kind of thing is done is via declaring local variables in
the SQL statement, and an example of doing such using