与sql不同的是,sql通过“+”号进行字符串拼接,而达梦是通过“||”符号进行字符串拼接的。
MySql是通过CONCA(字符串,拼接符,字符串)进行字符串拼接
举例说明:
SQL: Select EID as ID,badge+'-'+Name as Title from eemployee
达梦:Select EID As ID,Badge||'-'||Name As Title From eEmployee
MySql:Select EID,CONCAT(Badge,'-',NAME) From eEmployee