title: how to insert a column value in mysql
body: <p>A db table consists of 3 columns. But I want to insert a value to one column and I want the other 2 to remain empty. Like database has three input column- roll, date, time, I want only to insert roll. My query: </p>
  
  <pre><code>insert into tableName(roll) values ('$_POST['roll'])
  </code></pre>
  
  <p>But I am getting the error message ( Field <code>attn_time</code> doesn't have a default value41 ). What would be the correct query?<a href="https://i.stack.imgur.com/GYts5.jpg" rel="nofollow noreferrer">enter image description here</a></p>
  
  <p><a href="https://i.stack.imgur.com/Xs985.jpg" rel="nofollow noreferrer">database table</a></p>