title: how to insert data in only few column leaving other columns empty or as they are in a mysql table record?
body: <p>I have created a table named 'students'. It has following fields :</p>
  
  <pre><code> roll_no &lt;- type:Integer Not Null,
   course_name &lt;- type:varchar(40) Not Null,     
   std_surname &lt;- type:varchar(40) Not Null,
   std_firstname &lt;- type:varchar(40) Not Null,      
   emailid &lt;- type:varchar(40) ,   
   address &lt;- type:varchar(40) Not Null,
   income &lt;- type:Integer,        
   gender &lt;- type:varchar(10) Not Null,         
   experience &lt;- type:Integer, 
  </code></pre>
  
  <p>in the above fields mentioned some accept null values and most of them don't accept null values or null values are not allowed.</p>
  
  <p>What I want to do is I want to insert some information or data into the columns that do not accept null values and then I want to insert remaining data into the remaining columns later. How can I achieve this?</p>
  
  <p>More specifically how can I insert only few data into specific fields in a record at a time using insert query leaving other fields empty and then insert remaining field values like email or experience ???</p>
  
  <p>Please help me with this problem?</p>