title: sql insert only two values into a table with 10 fields
body: <p>My table has 10 fields: field1, field2,..., field10</p>
  
  <p>Now suppose i only want to insert values into first two columns, and put '' on the rest.</p>
  
  <p>I'm currently using </p>
  
  <pre><code>     insert into table1 values
    (100,200,'','','','','','','','','','')
  </code></pre>
  
  <p>I wonder if there is a better way to avoid ,'','','',''  ?</p>
  
  <p>Thanks for advice!</p>