title: Sum rows values in column on MySQL
body: <p>This is my sql query on database MySQL:</p>
  
  <pre><code>mysql&gt; SELECT
      sArea,
      `2014`,
      `2015`,
      `2016`,
      `2017`
  FROM
      `doTableAreas`
  WHERE
      LEFT (sArea, 2) IN ('XM');
  </code></pre>
  
  <p>And this is the output:</p>
  
  <pre><code>+-------+------+------+------+------+
  | sArea | 2014 | 2015 | 2016 | 2017 |
  +-------+------+------+------+------+
  | XM2A  |    0 |    1 |    4 |    5 |
  | XM2B  |    0 |  231 |  527 |   51 |
  | XM4A  |    0 |   87 |  287 |   46 |
  | XM4B  |    0 |   77 |  112 |    7 |
  | XM4C  |    0 |    0 |   42 |    1 |
  | XM6A  |    0 |   57 |  108 |   18 |
  | XM7A  |    0 |  280 |  456 |   52 |
  | XM7B  |    0 |  568 |  579 |   47 |
  +-------+------+------+------+------+
  8 rows in set
  </code></pre>
  
  <p>How to do for have this other output, instead, with total of single year?</p>
  
  <pre><code>+-------+------+------+------+------+
  | sArea | 2014 | 2015 | 2016 | 2017 |
  +-------+------+------+------+------+
  | XM2A  |    0 |    1 |    4 |    5 |
  | XM2B  |    0 |  231 |  527 |   51 |
  | XM4A  |    0 |   87 |  287 |   46 |
  | XM4B  |    0 |   77 |  112 |    7 |
  | XM4C  |    0 |    0 |   42 |    1 |
  | XM6A  |    0 |   57 |  108 |   18 |
  | XM7A  |    0 |  280 |  456 |   52 |
  | XM7B  |    0 |  568 |  579 |   47 |
  | Total |    0 |  1301|  2115|   227|
  +-------+------+------+------+------+
  </code></pre>
  
  <p>Thank you in advance.</p>