title: How to add new columns if needed
body: <p>I am new to MySQL databases and I'm trying to create a web stock and production database, using PHP.</p>
  <p>In this inventory software, I am trying to create a table in which products are created and also their components inserted. But if a product has a different number of components, I wanted to know if there is any way to add more components columns from the management page of the website.</p>
  <p>Another thing is that these components are taken from another table, and as long as a new product order is created, the quantity of those used components should be subtracted from the components table. (but this is a major issue, solving the first issue should be enough for now).</p>