Which option is correct?

Which option is true ?
Suppose there are two tables:
1. Category
2. Products

in this case, the product can be linked to multiple categories

1. To create a field of Product where do I specify id for example using the conditional operator to continue to use the sample via LIKE
2. Create a staging table which would be linked Category ID and Item ID

Thank you
July 2nd 19 at 13:34
4 answers
July 2nd 19 at 13:36
Solution
Clearly, the second option will be correct.
July 2nd 19 at 13:38
Solution
Through the intermediate correct 100%
July 2nd 19 at 13:40
Solution
I won 3rd!
Create a staging table which would be linked Category ID and Item ID
July 2nd 19 at 13:42
Agree with the above

Find more questions by tags Data structuresMySQL