//sql查询添加一列固定值
SELECT 表字段1,表字段2,表字段3,'固定值字符串' AS FixedStr FROM 表名称
SELECT _id as '客户ID',
name as '客户姓名',
'异常人员' as '标签名称'
from ods_mo_agents
WHERE labels like "%异常人员%"
//sql查询添加一列固定值
SELECT 表字段1,表字段2,表字段3,'固定值字符串' AS FixedStr FROM 表名称
SELECT _id as '客户ID',
name as '客户姓名',
'异常人员' as '标签名称'
from ods_mo_agents
WHERE labels like "%异常人员%"