CanMan2004 Posted August 27, 2006 Share Posted August 27, 2006 hi allI 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 advanceDave Link to comment https://forums.phpfreaks.com/topic/18833-copy-field-data/ Share on other sites More sharing options...
trq Posted August 27, 2006 Share Posted August 27, 2006 Ive not tried it but a simple UPDATE should work.[code]UPDATE tbl SET sourcefield=destfield;[/code] Link to comment https://forums.phpfreaks.com/topic/18833-copy-field-data/#findComment-81308 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.