SELECT
`a`.`id` AS `id`,
`a`.`proid` AS `proid`,
'属性' AS `fun_type`,
`a`.`name` AS `name`,
`a`.`identifier` AS `identifier`,
`a`.`datetype` AS `datetype`,(
CASE
WHEN ( `a`.`state` = 0 ) THEN
'未发布' ELSE '已发布'
END
) AS `state`,(
CASE
WHEN ( `a`.`accessmode` = 0 ) THEN
'读写类型:读写' ELSE '调用方式:只读'
END
) AS `accessmode`
FROM
`fc_pro_attr` `a` UNION
SELECT
`e`.`id` AS `id`,
`e`.`proid` AS
Navicat 创建视图 小案例
最新推荐文章于 2022-11-07 10:47:45 发布