SQL server 字段合并CAST(org_no AS VARCHAR(20)) CAST(page_no AS V
sql server 字段合并(CAST)
----------------------
select (CAST(org_no AS VARCHAR(20)) CAST(page_no AS VARCHAR(20)) CAST(djlb_no AS VARCHAR(20))) from ERP_BASIC_BILLNO_PREFIX where org_num=#{orgNum} and page_name=#{pageName} and djlb_name=#{djlbName};")
字段1+字段2
oracle 字段合并(CONCAT)
----------------------
select (Concat(Concat(CODE,‘_‘),NAME)) 合并结果集 from GoodsCate
mysql 字段合并(CONCAT)
----------------------
SELECT declare_type_id,support_model,project_name,CONCAT(declare_type_id,support_model,project_name) from gf_index;
温馨提示: 本文由Jm博客推荐,转载请保留链接: https://www.jmwww.net/SQL/21030.html
- 上一篇:mysql数据库的主从复制搭建与配置
- 下一篇:Python中mysql命令安装