我在MSSQL中有很多视图类似以下:
create view v_alarm
as
select alarmNo,is = case is when 1 then'是' when 0 then '否' end,taskName
from task
GO如何在mysql中实现这种视图?(is = case is when 1 then'是' when 0 then '否' end)
create view v_alarm
as
select alarmNo,is = case is when 1 then'是' when 0 then '否' end,taskName
from task
GO如何在mysql中实现这种视图?(is = case is when 1 then'是' when 0 then '否' end)
as
select alarmNo,case is when 1 then '是' when 0 then '否' end as `is`,taskName
from task;