select * from TableNameid idName1 A2 Bselect case id when 1 then '在售' else '售罄' end as 状况 from TableName状况在售售罄select case when id=1 then '在售'when id=2 then '售完' endas 状况 from TableName状况在售售罄
本文共 258 字，大约阅读时间需要 1 分钟。
select * from TableNameid idName1 A2 Bselect case id when 1 then '在售' else '售罄' end as 状况 from TableName状况在售售罄select case when id=1 then '在售'when id=2 then '售完' endas 状况 from TableName状况在售售罄
转载于:https://www.cnblogs.com/zeng-qh/p/7354449.html