Im new to MySQL RDMBS.
I know the basic CRUD if you know what i mean.
Create Read Update Delete.
I have 2 tables:
Category table and Product Table
Products should be categorized.
Product table has PK as an ID and FK to Category Table
How to INSERT INTO product table linking to specified Catageory Table?
How to SELECT products with same FK? as well as UPDATE and DROP?
Thanks in advance!