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, 204🔥, 0💬
Popular Posts:
Where to find tutorials to answer some frequently asked questions on Microsoft SQL Server Transact-S...
Where to find MySQL database server tutorials? Here is a collection of tutorials, tips and FAQs for ...
How To Calculate Age in Days, Hours and Minutes in SQL Server Transact-SQL? On many Web sites, news ...
How To Change the Name of a Database User in SQL Server? If you want to change the name of an existi...
What Is Oracle in Oracle? Oracle is a company. Oracle is also a database server, which manages data ...