添加链接
link之家
链接快照平台
  • 输入网页链接,自动生成快照
  • 标签化管理网页链接

MySQL中可以用进行cast(x AS type)累进行数据转换:

sql = "SELECT SUM(costMoney)  FROM user_cost WHERE companyId = 1 AND districtId = 2  "
>>>((Decimal('14450.00'),),)
sql = "SELECT cast(SUM(costMoney) AS CHAR) FROM user_cost WHERE companyId = 1 AND districtId = 2  "
>>>((('14450.00'),),)

可转换的type:

CHAR[(N)] 字符型