phpmyadmin sql to copy table fields?

[kuroi]

You would have to extend the product table to add the new columns, and the extension table would need a unique index in common with the product table (probably products_id). Then you could do something like

UPDATE products AS p, extension_table AS et
SET p.column_name_1 = et.column_name_1,
p.column_name_2 = et.column_name_2,
...
p.column_name_n = et.column_name_n
WHERE p.products_id = et.products_id;

[tvsupport]

Many thanks Kuroi that was just what I was after ! Just done a test and seems OK. products_id was the index of course. This was what I used on the copies of the tables

UPDATE zen_products1 AS p, zen_products_extra_stuff1 AS et
SET p.products_ref = et.products_ref
WHERE p.products_id = et.products_id;

I've eyeballed the result and it looks fine but now I'm going to run do some more checks to makes sure it really is OK before doing the live run.

Thanks again.