select CONCAT(address,city) as Address from student order by Address desc;
这是一个查询,用别名Address显示学生表中的地址和城市。
--- Program output ---
ADDRESS
----------------------------------------------------------------------
LMCCoimbatore
FFFVilupuram
BBBAgra
ABCSalem
AAAPondichery
--- Expected output (text)---
ADDRESS
------------------------------------------------------------------------
LMC, Coimbatore
FFF, Vilupuram
BBB, Agra
ABC, Salem
AAA, Pondichery
如何在城市和地址之间添加逗号和空格? 当我使用第三个字符串为“,”时,它会显示参数数量无效的错误。