phpmyadmin sql to copy table fields?

[tvsupport]

I have some extra product info fields in a separate table and now wish to copy them to the main product info table and am nervous of making a mistake.

Having backed up what is the most full proof method of adding and then copying the extra fields from one table to another using phpmyadmin? (really i'd like to know the correct syntax)

[kobra]

full proof method of adding and then copying the extra fields

Adding tables or adding records to existing tables is only a small part

What are you going to use for code to access/add to/display the data in these added fields??

Make a backup and suggest that you create a test/development instal for this versus trying this on your operational install

https://www.zen-cart.com/tutorials/i...p?article=103l

[tvsupport]

I've already got code to display the additional info in product info, product listing, basket, checkout, historic orders and in the admin (from another shop) but this was all based on storing the extra fields in the product table not in an 'extra stuff' table- so rather than doing a lot of re-writes I thought I'd go this route.

Anyhow I've decided to make copies of the two tables and try the merge. I'll export the data before and after into excel and do a compare - then when I'm sure it's woking like I want I'll do it for real.

[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.