I am new to mysql and have two problems.
- I have two tables that need to have same values from one field , if that values are not same in second table change it to value of first table
Frist table is ps_product and they all need to have same id_product, the value that I need to change or check is id_category_default and if they are not the same put value in ps_product_shop to be same id_category_default as in ps_product
Can that be done for every entry?
- Can I do something like;
To check if the value is 5 in one table then if in second table for same id is 0, put 5 there, also if there is no such id in second table create it and add values from frist table? To go ver all id's and check if they exist in second table?