how to insert data in only few column leaving other columns empty or as they are in a mysql table record?
<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>