[lordmerlin]

Hi

I have two tables, companies and tradealerts.
Companies has about 25 fields, and currently about 24700 odd entries.
tradealerts has 9 fields, and rougly about 290 entries.
The only similarity between the two is a field called compid (which is the company id), countryid and classification.

Now, I want all the records in the companies table to be in the tradealerts table, but I'm just not sure howto do this.

I had a look on the mysql website, and I couldn't see anything in this line, other than update, like this:

UPDATE companies,tradealerts SET tradealerts.classifications=companies.classificati ons

This is all good and well, but it doesn't work for me. I want all 24700 odd records to be duplicated into the tradealerts table.

Almost like:

INSERT into tradealerts(compid,classifications,countryid) VALUES ("companies.compids","companies.classifications",c ompanies.coutryid")

Is there a way of doing this?

[SIR-Millar]

if this is a one off, perhaps consider making a PHP script to copy from one to another?

[lordmerlin]

Well, not really, cause quite soon we'll be uploading a few more entried to the database, and then in a few months time again. The data get's generated by another company, and we get it in batches of a few thousand at a time.

So yes, the script sounds like a good idea, but how do I write it? The main consern is that it should skips rows where companies.compid = tradealets.compid.

Do you maybe have a suggestion as howto make this script? Or even just a scrpt to copy it over?