I hope you all know a better way of doing this because atm I feel like a moron. =( hehe
What happened is this. I have a 150MB table with about 6 fields. I accidentally only made one of the fields int(4) when it should have been int(6), effectively cutting off 1, sometimes 2 digits from the data I imported. In order to fix this, because the table has already been used and dynamically changed, I made a second table with the exact structure (changed both those fields to int(6)) and imported all the data into there. I have a field that is unique (zipplusfour) and I'm looking to update the home_number field from movers_backup to movers. Now if I had MySQL 4 I would run a joined UPDATE command but since we're running 3.23 I have to write a program to do it. =( When I run the following command though, it returns numbers that do NOT match up correctly... can anyone tell me why?
SELECT movers.home_number, movers_backup.home_number FROM movers,movers_backup WHERE movers.zipplusfour=movers_backup.zipplusfour LIMIT 5;
I'm afraid to run the update command if it's going to screw over the old table hardcore. It's in use heavily ATM, and thank God this isn't too much of an issue because few people have 5 digit house numbers. 😛
Thanks in advance for any help that can be given,
Tom =)
