I am creating a shopping database, I have two tables: 1. shopping_list and 2. recipes. in #2 recipes fields: recipe_name, ingredients, amount, cost etc.
in #1 (shopping_list) fields of shop_ingredients, shop_amount, etc. So, I would like to add the ingredients from "recipes" into "shopping_list" and at the same time, check to avoid any duplicate ingredients in the "shopping_list".
Can anyone help me to start building this script?