kalster Posted June 21, 2013 Share Posted June 21, 2013 i need to change only one field by swap and keep the rest of the values for those rows. for example, x in row one has a value of 2 and the x in the other row has a value of 3. i need to swap only x for those rows. UPDATE swap_test SET x=(@temp:=x), x = y, y = @temp; Link to comment https://forums.phpfreaks.com/topic/279409-swap-two-rows/ Share on other sites More sharing options...
Barand Posted June 21, 2013 Share Posted June 21, 2013 Use the rows' primary keys to identify which x should get which value Link to comment https://forums.phpfreaks.com/topic/279409-swap-two-rows/#findComment-1437300 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.