TalkPHP - View Single Post

Runar · 11-06-2008, 03:34 PM

I apologize. SQL in general is far from my favourite field, so I am not sure if this will help you or not. You could use the following method to only copy certain fields between the two tables, like for cases when one or both of the tables contains unique fields. Maybe that is what you are looking for:

Code:

INSERT `call_in` (`time`, `date`, `company_id`, <more fields>) SELECT `time`, `date`, `company_id`, <more fields> FROM `online_report`

11-06-2008, 03:34 PM	#6 (permalink)
Runar The Contributor Join Date: Nov 2008 Location: Norway Posts: 58 Thanks: 20	I apologize. SQL in general is far from my favourite field, so I am not sure if this will help you or not. You could use the following method to only copy certain fields between the two tables, like for cases when one or both of the tables contains unique fields. Maybe that is what you are looking for: Code: INSERT `call_in` (`time`, `date`, `company_id`, <more fields>) SELECT `time`, `date`, `company_id`, <more fields> FROM `online_report`