引言:
当数据库设置字段的时候,会设置1表XXX;0表示XXX。查询的时候怎么显示汉字呢?
Oracle数据库:
普通查询数据:
select * from U_ORANGEZATION
匹配查询数据:
select
ORG_ID,ORG_NAME,PARENT_ORD_ID,CREATE_TIME,CREATE_USERCODE,
CREATE_USERANME,MOFDIFY_TIME,MODIFY_USERCODE,MODIFY_USERNAME,
decode(DATA_STATE,0,'禁用',1,'启用') as DATA_STATE
from U_ORANGEZATION
Sql Server 数据库:
普通查询数据:
SELECT
dbo.tb_GoodsInfo.GoodsID,dbo.tb_GoodsInfo.GoodsTypeID,dbo.tb_GoodsInfo.GoodsName,dbo.tb_GoodsInfo.GoodsIntroduce,dbo.tb_GoodsInfo.GoodsPrice,dbo.tb_GoodsInfo.GoodsPhoto,dbo.tb_GoodsInfo.GoodsDate,dbo.tb_GoodsInfo.GoodsIsNew
FROM
dbo.tb_GoodsInfo
匹配查询数据:
select
case when dbo.tb_GoodsInfo.GoodsID=1 then'男' when dbo.tb_GoodsInfo.GoodsID=100 then '女' end as GoodsID
from dbo.tb_GoodsInfo
Excel:
3个字段:
=if(A1=1,"未完成",if(A1="","完成","其他"))
2个字段:
=if(A1=1,"未完成",“已完成")