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, 1323🔥, 0💬
Popular Posts:
How to run Queries with SQL Server Management Studio Express in SQL Server? 1. Launch and connect SQ...
How To Download Oracle Database 10g XE in Oracle? If you want to download a copy of Oracle Database ...
How To Calculate Age in Days, Hours and Minutes in SQL Server Transact-SQL? On many Web sites, news ...
What Is Oracle in Oracle? Oracle is a company. Oracle is also a database server, which manages data ...
How To Get a List of All Tables with "sys.tables" View in SQL Server? If you want to see the table y...