CONCAT(str1, str2,...)的含义是将 str1,str2,... 直接连接起来
完整代码:
SQLite
SELECT last_name || "'" || first_name FROM employees
MySQL
select CONCAT(last_name,"'",first_name)
from employees
CONCAT(str1, str2,...)的含义是将 str1,str2,... 直接连接起来
完整代码:
SQLite
SELECT last_name || "'" || first_name FROM employees
MySQL
select CONCAT(last_name,"'",first_name)
from employees