Moving parent categories into another category using PHPMyAdmin

[philee]

I currently have 500 products in one of my parent category and 300 products in another parent category, and I want to place both of those category into one.

The categories ID are 29 and 192, and I want to move those two into the new category 495 using PHPMyAdmin.

Whats the query command I should run to get this taken care of?

Thank you in advance.

[Ukoo - Guillaume]

I did'nt test but you can do something like this :

UPDATE ps_category_product
SET id_category = 495
WHERE id_category = 29
OR id_category = 192;

AND

UPDATE ps_product
SET id_category_default = 495
WHERE id_category_default = 29
OR id_category_default = 192;

Test with one product and execute if it works...