Good day, and so the question: I now have a data table with the n-th number of columns, etc. And there are for example 2 columns, 1 for selecting a category, let's say, another for selecting a performer. In the database entry is in the form of ID. cat_id and emp_id. If a record does not fall under one category, that is, there is no such category or a lot of categories, how can I store data? Create pivot table? Or after filling out the custom input field, a new entry was created in the category table? How will be better and more correct?

  • one
    Apparently there is no category - no entry. many categories - many entries. the question is not particularly clear at all - Mike
  • lynn bailey sql read - Jean-Claude

0