This is the SQL statement:
mysql -u user -p password -e "SELECT concat(name,'-',number) from users
where email='test@test.com'"
Expected output: john-1234
Actual output: concat(name,'-',number)
john-1234
Why is this happening?
Asked
Active
Viewed 161 times
-1
-
4That's the column name. Try `... concat(name,'-',number) as XYZ ...` and see what happens. – jarlh Feb 14 '19 at 10:28
-
I'm using this command in bash and it's extra work to split the output. Is there a way that I can only return the result? – Barath R Feb 14 '19 at 10:30
-
@Cid You're right. Got the answer I needed. Thanks! – Barath R Feb 14 '19 at 10:32
3 Answers
0
MySQL will return column names. You can give it a more useful alias like this:
SELECT concat(name,'-',number) as username from users
where email='test@test.com'
EDIT: Looks like @jarlh beat me to it in the comments.
Jim Wright
- 5,905
- 1
- 15
- 34
0
just give an alias of your column name other wise it will concat(name,'-',number) as column name
"SELECT concat(name,'-',number) as output from users
where email='test@test.com'"
Zaynul Abadin Tuhin
- 31,407
- 5
- 33
- 63
0
It is name of the column.
You can name it in other way:
SELECT concat(name,'-',number) AS nameAndNumber from users where email='test@test.com'
Vlad Hanzha
- 464
- 3
- 11