Jump to content


Photo

copy field data


  • Please log in to reply
1 reply to this topic

#1 CanMan2004

CanMan2004
  • Members
  • PipPipPip
  • Advanced Member
  • 254 posts

Posted 27 August 2006 - 09:00 PM

hi all

I have loads of rows in my database and I want to run a query to copy the contents of one field in a specified row to another field on the same row, basically passing data from one field to another but the data and the data that is passed is always on the same row.

Can anyone help me?

Thanks in advance

Dave

#2 trq

trq
  • Staff Alumni
  • Advanced Member
  • 31,041 posts

Posted 27 August 2006 - 10:28 PM

Ive not tried it but a simple UPDATE should work.

UPDATE tbl SET sourcefield=destfield;





0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users