jim.davidson Posted November 12, 2010 Share Posted November 12, 2010 I'm new to mySQL. I have a mySQL table and data was entered into the wrong field. I need to move all data from field A to field B. What's the quickest way? Any help will be appreciated. Link to comment https://forums.phpfreaks.com/topic/218511-data-in-wrong-field/ Share on other sites More sharing options...
Pikachu2000 Posted November 12, 2010 Share Posted November 12, 2010 I'd probably do it in two steps: UPDATE `table` SET `field1` = `field2` Then (after you make sure the above was successful): UPDATE `table` SET `field2` = '' Link to comment https://forums.phpfreaks.com/topic/218511-data-in-wrong-field/#findComment-1133571 Share on other sites More sharing options...
jim.davidson Posted November 12, 2010 Author Share Posted November 12, 2010 Thank you Link to comment https://forums.phpfreaks.com/topic/218511-data-in-wrong-field/#findComment-1133575 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.