title: INSERT in a single column, the rest of the column will have a default value
body: <p>How to insert a default value in all columns after inserting a value in a single column,</p>
  
  <p>Example: I created a <code>product</code> table and the columns are <code>id (autoincrement)</code>, <code>product_name</code>, and <code>item</code>.</p>
  
  <pre><code>CREATE TABLE product
  (
      id int AUTOINCREMENT,
      product_name varchar(255),
      item int
  );
  </code></pre>
  
  <p>How can I insert only the <code>product_name</code> and have the item automatically populated with the value <code>30</code>?</p>
  
  <pre><code>insert into 
      product 
  values (
      'burger'
  )
  </code></pre>
  
  <p>and have the result be </p>
  
  <pre><code>id: product_name:  item: 
  7   burger         30
  </code></pre>