Mysql Select statement

Question

I am querying a database as:

SELECT SUM(Hours) 
  from User 
 where surname = 'johnson';

Whenever I run it, as you know it will show selected Column with the name SUM(Hours).

Question:

Is there any way that I can "rename" it without altering the database table?

Bogdan Constantinescu · Accepted Answer · 2011-03-09 23:06:19Z

5

You have to do something like this:

SELECT SUM(Hours) AS sumHours FROM User WHERE surname='johnson';

Now your column name is sumHours. You can name it whatever you want, but keep in mind to be descriptive.

answered Mar 9, 2011 at 23:06

Bogdan Constantinescu

5,3864 gold badges42 silver badges51 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Bogdan Constantinescu Over a year ago

You just have to add AS whatColumnNameYouWant after SUM(Hours) and after that you will see the result as whatColumnNameYouWant. It works. Used it million times :)

OMG Ponies Over a year ago

@7dr3am7: The AS keyword is a supported feature for specifying a column alias in MySQL since 4x IME. Your issue, whatever it is, is then unlikely to be the column alias. Provide more detail than "it doesn't work" if expect anyone to answer you. It's possible you're trying to specify an alias that is a registered keyword, which would require enclosing in backticks to work... or you could just not use registered keywords in your queries as column names.

7dr3am7 Over a year ago

You won't believe it guys but.... O.O 48 hours of non sleep can make you put semicolons around a very simple SQL STATEMENT! O.O THANK you all.. I think I will go to sleep now....thank you all for your patient

nickmoriarty · Accepted Answer · 2011-03-09 23:06:48Z

1

SELECT SUM(Hours) as hours from User where surname='johnson';

answered Mar 9, 2011 at 23:06

nickmoriarty

1,26319 silver badges23 bronze badges

2 Comments

nickmoriarty Over a year ago

@Johan You do realize we both answered this at almost the same time, so I wouldn't have seen the other answer until after mine was posted. You might want to look closer before you downvote just to get your badge.

Johan Over a year ago

Sorry 'bout that did not mean to earn my batch off of your karma, will up vote somewhere to compensate.

Collectives™ on Stack Overflow

Mysql Select statement

Question:

2 Answers 2

3 Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

Question:

2 Answers 2

3 Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related