SQL command to move records

[gilescis]

My db has 4 fields
name,phone,email1,email2,week

My current records have data in email1 field. Email2 field is currently blank. I want to move the email addresses in email1 over to email2 but keep them inline with name,phone,week.

Will this command do it for me

Update tblName set fieldA = fieldB;
Update tblName set fieldB = null;


I will also have to select all the records first that week=4 then move the email1 info to email2

I dont necessaraly have to del email1 field because my import will take care of that.

Thanks

 

[pbaldy]

Yes, that will do it for you.