您好,请问如何在mysql数据库里查询某一个主机的所有触发器信息呢?有哪些表的字段可以关联起来?
SELECT triggers.description FROM triggers JOINfunctionsONfunctions.triggerid = triggers.triggerid JOIN items ON items.itemid = functions.itemid JOIN hosts ON hosts.hostid = items.hostid WHERE hosts.host = '指定主机名称'; 可参考上述sql语句
错误信息