Change the jos_ prefix to the prefix you are using.

-- set stock of selected products (based on ID)
UPDATE jos_phocacart_products SET stock = '10000' WHERE id > 0 AND id < 5;