kkreft
12/9/2015 - 12:25 PM

Source: http://stackoverflow.com/a/559291

UPDATE swap_test SET gps_lat=(@temp:=gps_lat), gps_lat = gps_lng, gps_lng = @temp;