title: MySQL INSERT two fields only
body: <p>I have a table with quite a few columns. The total number of columns is not yet specified, and will change on a regular basis.</p>
  
  <p>In my insert query, I only need to put two values into the table. All other values will be ' '. is there a way to only specify the first fields, without having to include '','','',''...? Please see below for example:</p>
  
  <p>I would like to have this:</p>
  
  <pre><code>$query = mysql_query("INSERT INTO table VALUES('','$id')");
  </code></pre>
  
  <p>Rather than this:</p>
  
  <pre><code>$query = mysql_query("INSERT INTO table VALUES('','$id','','','','','',''......and on and on...)");
  </code></pre>
  
  <p>Is there a way to do this? Thanks!</p>