title: UPDATE multiple columns using on query in MySQL
body: <p>I need to set the city_populations Column as follows using 1 CASE command in my table 'customers'</p>
  
  <pre><code>Barrie      =   177,061
  Toronto     =   2,480,000
  Collingwood =   17,290
  Thunder Bay =   108,359
  </code></pre>
  
  <p>Ive created 2 querys, but it wont run, any suggestions.</p>
  
  <pre><code>UPDATE customers
  SET city_population Barrie = 177061, 
                      Toronto = 2480000,
                      Collingwood = 17290, 
                      Thunder Bay =108359 
  WHERE city = 'Barrie', 'Toronto', 'Collingwood', 'Thunder Bay';
  
   UPDATE customers
   SET city_population = 177061, 2480000, 17290, 108359 
   WHERE city = 'Barrie', 'Toronto', 'Collingwood', 'Thunder Bay';
  </code></pre>