title: MySQL inheritance?
body: <p>What would be the best way to design this MySQL database?</p>
  
  <p>I have <code>cars</code>, <code>fuels</code>, and <code>motor oils</code>. Each car can use any number of <code>fuels</code> and any number of <code>motor oils</code>. What would be the best way to design this database?</p>
  
  <p>So, one <code>car</code> can have one or many <code>fuels</code>, and one or many <code>motor oils</code>.</p>
  
  <p>So I would need to have <code>cars</code>, <code>fuels</code>, and <code>motor_oils</code> tables in my database.
  Now since <code>fuels</code> and <code>motor_oils</code> have some similar properties like price, date_produced etc.
  Would it be smart for me to create another table called lets say <code>products</code>?</p>
  
  <p>When using OOP language I would have <code>Product</code> entity, <code>Fuel</code> and <code>MotorOils</code> would extend <code>Product</code> and this way have properties defined in <code>Product</code>.</p>
  
  <p>How would I design this in Mysql database? Is there such thing as inheritance in MySQL?
  I know that relation database does not have inheritance, and that there is a way to mimic this in MySQL, just need someone to explain better how is this done?</p>