MySQL中的CONCAT()

Question

我需要一个像500000 (Cr)这样的输出，我尝试了如下：

SELECT CONCAT(SUM(transactioninfo.CreditAmount),'Cr')
   AS creditdAmount FROM transaction;

但我只得到了500000。

表结构：

Id CreditAmount DebitAmount Transactiondate
-- ------------ ----------- ---------------
1   100000            0         2015-12-08
2   100000          5000          2015-12-08
3   100000          2000          2015-12-08
4   100000          3000          2015-12-08
5   100000          5000          2015-12-08

Answer 1

您可以尝试将您的价值转换为varchar，然后尝试如下：

SELECT  CONCAT(CAST(SUM(transactioninfo.CreditAmount) AS char(20)),' (Cr)') AS creditdAmount FROM transactioninfo;

Answer 2

请检查以下内容。这对你来说是值得的：

SELECT 
CONCAT(CONVERT(SUM(transactioninfo.CreditAmount), char), ' (Cr)') AS creditdAmount 
FROM transactioninfo

Answer 3

您可以使用此查询。

 SELECT concat(creditdAmount,' (Cr)') FROM  
   (  
    SELECT SUM(id) AS creditdAmount FROM transaction  
   )as temp;