title: Adding a new column with data
body: <p>Below is my table:</p>
  
  <pre><code>Id  Name    City    Managerid  
  ------------------------------
  1   Shawn   NYC     3
  2   Kevin   Mumbai  4
  3   Ryan    Mumbai  1
  4   Kanye   SF      1
  </code></pre>
  
  <p>Now I want to add a new column called 'Gender' with values <code>M,M,M,F</code> in 4 rows respectively.</p>
  
  <p>I first added a new column using:</p>
  
  <pre><code>alter table employee add gender varchar(50)
  </code></pre>
  
  <p>Now I understand I can add data one by one by using:</p>
  
  <pre><code>update employee 
  set gender = 'M' 
  where id = 1
  </code></pre>
  
  <p>But how do I add all 4 data at once?</p>