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
2023-12-19, 198🔥, 0💬
Popular Posts:
How To Update Multiple Rows with One UPDATE Statement in SQL Server? If the WHERE clause in an UPDAT...
Where to find answers to frequently asked questions on Downloading and Installing SQL Server 2005 Ex...
Is PL/SQL Language Case Sensitive in Oracle? PL/SQL language is not case sensitive: Reserved words a...
What Are Out-of-Range Errors with DATETIME values in SQL Server Transact-SQL? When you enter DATETIM...
How To Generate CREATE VIEW Script on an Existing View in SQL Server? If you want to know how an exi...