sql - how to join two string columns into one in MySQL -


i have table

________________ | authors       | |name  | surname| |------|--------| |jeff  | lindsay| |george| martin | |______|________| 

and need join these 2 columns 1 space between them. tried

select (name + ', ' + surname) name authors 

but returns me this:

 ________________ |    name       | |      0        | |      0        | |_______________| 

how join these 2 have full name?

in mysql called concat

select concat(name,' ',surname) fullname author 

Comments

Popular posts from this blog

java - Intellij Synchronizing output directories .. -

git - Initial Commit: "fatal: could not create leading directories of ..." -