I can get all products that doesn't have category with this query, how can I update them with an category id considering this query to select:
SELECT e.entity_id,e.sku
FROM catalog_product_entity AS e
LEFT JOIN catalog_category_product AS l ON l.product_id = e.entity_id
WHERE l.category_id IS NULL
I need to set
UPDATE `catalog_category_product` SET l.category_id = '132' WHERE l.category_id IS NULL
SQLFIDDLE:http://sqlfiddle.com/#!2/59b01/2