MySql - use of ALIAS for multiple columns

Question

I saw the following code:

SELECT 
    u.ID, u.username, u.active, u.email, u.admin, u.banned, 
    u.name AS groupmemberships 
FROM users u 
WHERE u.ID={$uid}

and was wondering where the official documentation about aliasing multiple columns was. W3schools (not the best source) as the only place where I found "documentation" in the following way:

SELECT column_name(s) FROM table_name AS alias_name;

http://www.w3schools.com/sql/sql_alias.asp

I would appreciate a link to official documentation so I can look it over.

Is it aliasing multiple columns? Looks like this will just alias u.name AS groupmemberships the other columns will still be whatever they're normally called. — Taryn East
– Taryn East, Commented Aug 7, 2013 at 0:44
I agree with @Taryn East, and we generally use alias when joining tables. — RoMEoMusTDiE
– RoMEoMusTDiE, Commented Aug 7, 2013 at 1:24
Robert, there are hundreds of on-line explanations of SQL, and dozens of them are official (because it is provided by many softwares; some differences, but not great). Suggest you run a search on keywords MySQL ALIAS. — Smandoli
– Smandoli, Commented Aug 7, 2013 at 14:48
You can alias an expression or column, such as in select u.id as user_id and select upper(u.username) as uppercase_name, and you can alias a table as in from users u. There exists no group alias for multiple columns. Does this answer your question? Well, you haven't really asked a question, though ... — Thorsten Kettner
– Thorsten Kettner, Commented Sep 6, 2018 at 11:32

Community · Accepted Answer · 2017-05-23 12:20:23Z

3

You can't use the same alias for multiple columns, but you can concatenate values and give the result an alias:

SELECT 
  u.ID, u.username, u.active, u.email, u.admin, u.banned, 
  u.name + u.username AS groupmemberships 
FROM users u

If this is what you want, then check here for how to deal with null values.

edited May 23, 2017 at 12:20

CommunityBot

11 silver badge

answered Aug 7, 2013 at 0:48

Smandoli

7,0593 gold badges53 silver badges83 bronze badges

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

Comments

Praveen · Accepted Answer · 2018-09-06 12:25:16Z

2

You can use concat function to get single alias for multiple columns,

 select concat(first_name, ' ', last_name) as employee_name from user;

edited Sep 6, 2018 at 12:25

Praveen

1,8913 gold badges21 silver badges36 bronze badges

answered Sep 6, 2018 at 11:23

Justin J

8508 silver badges14 bronze badges

Collectives™ on Stack Overflow

MySql - use of ALIAS for multiple columns

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related