MYSQL concat命令

concat 本身是用来连接两个字符串的
concat_ws(分界符，“”，“”，“”…) 用分节符来连接字符串

SELECT concat(author_fname,' ',author_lname) FROM books;
+----------------------+
| full_name            |
+----------------------+
| Jhumpa Lahiri        |
| Neil Gaiman          |
| Neil Gaiman          |


//第一个‘-‘是分隔符，author_fname和author_lname之间会用'-'分隔开
SELECT concat_ws('-',author_fname,author_lname) FROM books;
+------------------------------------------+
| concat_ws('-',author_fname,author_lname) |
+------------------------------------------+
| Jhumpa-Lahiri                            |
| Neil-Gaiman                              |
| Neil-Gaiman                              |
| Jhumpa-Lahiri                            |
| Dave-Eggers                              |
| Dave-Eggers                              |
| Michael-Chabon                           |