title: How to INSERT data into a specific column without NULLs in the other columns?
body: <p>I have a table (&quot;table1&quot;) with 3 columns called col1, col2 and col3 (each is VARCHAR) with 4 values as shown below:</p>
  <pre><code>col1   col2   col3
  datA1  datB1  datC1
  datA2  
  </code></pre>
  <p>I need an ability to add a data at any time into any column NOT affecting on the other ones. The very popular code in the Internet is that (say, we need to add data only to the columns col2 and col3):</p>
  <pre><code>INSERT INTO table1 (col2, col3)
  VALUES ('datB2', 'datC2');
  </code></pre>
  <p>But it adds new rows, like below:</p>
  <pre><code>col1   col2   col3
  datA1  datB1  datC1
  datA2
  NULL   datB2  datC2
  </code></pre>
  <p>What I really need is to fill the row starting with value &quot;datA2&quot; at the column &quot;col1&quot; with new values and get the table like below:</p>
  <pre><code>col1   col2   col3
  datA1  datB1  datC1
  datA2  datB2  datC2
  </code></pre>
  <p>The table has 3 columns and each column responses for a particular type of values (say: name, colour, size). What I need is just a possibility to add new values at any time in a particular column and have them without Null and new rows if it has a free cell before.</p>