title: changing column name in mysql from sum(xyz) to xyz
body: <p>In MySQL, how do I change the column name of a table from "sum(xyz)", to say "xyz"? I have tried the following solutions for just changing the column name: </p>
  
  <p><a href="https://stackoverflow.com/questions/4224662/change-column-name-in-mysql">Change Column Name in MySQL</a> </p>
  
  <p><a href="https://stackoverflow.com/questions/16296622/rename-column-sql-server-2008">Rename column SQL Server 2008</a></p>
  
  <p>However, it always throws up an error saying that the syntax is not right. I feel that it is because of the sum() function, because it doesn't allow me to use SELECT on that column too (when done separately).
  Is there any way past this? A solution to access the values in that column without changing the column header is also appreciated!</p>
  
  <p>I am using WAMPSERVER to run MySQL version 5.1.53.</p>
  
  <p>Thanks</p>