Collections:
ROLES_GRAPHML() - User Role Graph in GraphML Format
How to obtain User Role Graph in GraphML Format using the ROLES_GRAPHML() function?
✍: FYIcenter.com
ROLES_GRAPHML() is a MySQL built-in function that
returns user role graph in GraphML format.
For example:
SELECT ROLES_GRAPHML(); -- +--------------------------------------------------------------------+ -- | ROLES_GRAPHML() | -- +--------------------------------------------------------------------+ -- | <?xml version="1.0" encoding="UTF-8"?> <graphml xmlns="http://graphml.graphdrawing.org/xmlns" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://graphml.graphdrawing.org/xmlns http://graphml.graphdrawing.org/xmlns/1.0/graphml.xsd"> <key id="key0" for="edge" attr.name="color" attr.type="int" /> <key id="key1" for="node" attr.name="name" attr.type="string" /> <graph id="G" edgedefault="directed" parse.nodeids="canonical" parse.edgeids="canonical" parse.order="nodesfirst"> <node id="n1"> <data key="key1">`mysql.infoschema`@`localhost`</data> </node> <node id="n2"> <data key="key1">`mysql.session`@`localhost`</data> </node> <node id="n3"> <data key="key1">`mysql.sys`@`localhost`</data> </node> <node id="n4"> <data key="key1">`root`@`localhost`</data> </node> <node id="n5"> <data key="key1">`fyi`@`localhost`</data> </node> <node id="n16"> <data key="key1">`fyi`@`%`</data> </node> </graph> </graphml> -- +--------------------------------------------------------------------+
Reference information of the ROLES_GRAPHML() function:
ROLES_GRAPHML(): xml Returns user role graph in GraphML format. Arguments, return value and availability: xml: Return value. user role graph in GraphML format. Available since MySQL 4.0.
⇒ ROW_COUNT() - Affected Rows from Last DML Statement
⇐ PS_THREAD_ID() - PS Thread ID of Given Connect
2025-02-16, 766🔥, 0💬
Popular Posts:
What Is ISAM in MySQL? ISAM (Indexed Sequential Access Method) was developed by IBM to store and ret...
What Are Bitwise Operations in SQL Server Transact-SQL? Bitwise operations are binary operations per...
How To Turn on mysql Extension on the PHP Engine in MySQL? The "mysql" API extension is provided as ...
How To Format Time Zone in +/-hh:mm Format in SQL Server Transact-SQL? From the previous tutorial, y...
How to execute statements under given conditions in SQL Server Transact-SQL? How to use IF ... ELSE ...