title: In SQL, is it possible to use a dummy column in an insert statement?
body: <p>So I have some insertion:</p>
  
  <pre><code>insert into table (col1, col2, dummy, col3) values (1,1,1,1), (2,2,2,2)
  </code></pre>
  
  <p>The "dummy" column doesn't really exist, it's needed because I generate the insert statement, even the column header, and some columns need to be ignored based on situation, but the data are still the same, it would make my life a lot easier if I don't need to mess with the data and just the header.</p>
  
  <p>So I guess to put it another way:  Is it possible to "ignore" a column on insert statement.</p>
  
  <hr>
  
  <p>To put it in another another way, I am trying to do a insert statement on 3 columns with 4 columns worth of data, and is wondering if there is any way to deal with this at the SQL level instead of at the code logic level.</p>
  
  <hr>
  
  <p>So here is a longer example, I have this 2D array.</p>
  
  <pre><code>{ {101,102,103,104}, {201,202,203,204}, ... }
  </code></pre>
  
  <p>I have a table with the following columns</p>
  
  <pre><code>col1, col2, col3, col4
  </code></pre>
  
  <p>Now one user says:  </p>
  
  <pre><code>"I would like to only use col1, col2, col4"
  </code></pre>
  
  <p>And another user says:</p>
  
  <pre><code>"I would like to only use col2, col3"
  </code></pre>
  
  <p>How do I do this if I do not want to mess with the 2D data array?  </p>
  
  <pre><code>insert into table (col1, col2, ignore, col4) 
      values (101,102,103,104), (201,202,203,204)
  
  
  insert into table (ignore, col2, col3, ignore) 
      values (101,102,103,104), (201,202,203,204)
  </code></pre>
  
  <p>Notice that the order matters.</p>