惯性聚合 高效追踪和阅读你感兴趣的博客、新闻、科技资讯
阅读原文 在惯性聚合中打开

推荐订阅源

S
Security Archives - TechRepublic
MongoDB | Blog
MongoDB | Blog
量子位
博客园 - 叶小钗
罗磊的独立博客
cs.AI updates on arXiv.org
cs.AI updates on arXiv.org
Hacker News: Ask HN
Hacker News: Ask HN
MyScale Blog
MyScale Blog
GbyAI
GbyAI
Help Net Security
Help Net Security
Y
Y Combinator Blog
Engineering at Meta
Engineering at Meta
Hacker News - Newest:
Hacker News - Newest: "LLM"
Latest news
Latest news
H
Hacker News: Front Page
Blog — PlanetScale
Blog — PlanetScale
雷峰网
雷峰网
Microsoft Azure Blog
Microsoft Azure Blog
P
Proofpoint News Feed
C
CXSECURITY Database RSS Feed - CXSecurity.com
Scott Helme
Scott Helme
S
Schneier on Security
博客园 - 司徒正美
Hugging Face - Blog
Hugging Face - Blog
S
Security @ Cisco Blogs
Recorded Future
Recorded Future
S
Securelist
博客园 - Franky
Application and Cybersecurity Blog
Application and Cybersecurity Blog
A
About on SuperTechFans
N
News and Events Feed by Topic
AI
AI
T
Tenable Blog
N
News | PayPal Newsroom
C
Cybersecurity and Infrastructure Security Agency CISA
V
V2EX - 技术
T
Threat Research - Cisco Blogs
Cisco Talos Blog
Cisco Talos Blog
L
LINUX DO - 热门话题
N
Netflix TechBlog - Medium
S
SegmentFault 最新的问题
T
The Blog of Author Tim Ferriss
钛媒体:引领未来商业与生活新知
钛媒体:引领未来商业与生活新知
Google Online Security Blog
Google Online Security Blog
S
Security Affairs
Webroot Blog
Webroot Blog
D
Darknet – Hacking Tools, Hacker News & Cyber Security
博客园 - 三生石上(FineUI控件)
C
Comments on: Blog
G
GRAHAM CLULEY

博客园 - window07

Hibernate缓存机制 Facebook 的 Scaling Out 经验 软件架构设计 mysql的FLUSH句法(清除缓存) 优化MySQL数据库性能 MySQL系统变量interactive_timeout 与 wait_timeout INSERT … ON DUPLICATE KEY UPDATE Howto change runtime variables without restart MySQL Server MySQL 5.1新特性之事件调度器(Event Scheduler) GROUP_CONCAT()妙用 Mysql参数配置优化说明 MySQL 备份和恢复 error: Failed dependencies: MySQLconflicts flash的socket连接安全策略文件 缓存系统MemCached的Java客户端优化历程 使用java.util.zip对字符串进行压缩和解压缩 Java和flash通信中数据的zlib压缩与解压缩 反序列化时出现“base-64 字符数组的无效长度”错误提示的解决 关于GC垃圾回收
MYSQL命令行导出XML格式数据 - window07 - 博客园
window07 · 2009-11-04 · via 博客园 - window07

使用“-X”这个选项即可。

# mysql -X -u root -e "use mysql; select * from user;"

输出结果如下:

<?xml version="1.0"?>
 
<resultset statement="select * from user">
  <row>
        <field name="Host">localhost</field>
        <field name="User">root</field>
        <field name="Password"></field>
        <field name="Select_priv">Y</field>
        <field name="Insert_priv">Y</field>
        <field name="Update_priv">Y</field>
        <field name="Delete_priv">Y</field>
        <field name="Create_priv">Y</field>
        <field name="Drop_priv">Y</field>
        <field name="Reload_priv">Y</field>
        <field name="Shutdown_priv">Y</field>
        <field name="Process_priv">Y</field>
        <field name="File_priv">Y</field>
        <field name="Grant_priv">Y</field>
        <field name="References_priv">Y</field>
        <field name="Index_priv">Y</field>
        <field name="Alter_priv">Y</field>
        <field name="Show_db_priv">Y</field>
        <field name="Super_priv">Y</field>
        <field name="Create_tmp_table_priv">Y</field>
        <field name="Lock_tables_priv">Y</field>
        <field name="Execute_priv">Y</field>
        <field name="Repl_slave_priv">Y</field>
        <field name="Repl_client_priv">Y</field>
        <field name="Create_view_priv">Y</field>
        <field name="Show_view_priv">Y</field>
        <field name="Create_routine_priv">Y</field>
        <field name="Alter_routine_priv">Y</field>
        <field name="Create_user_priv">Y</field>
        <field name="ssl_type"></field>
        <field name="ssl_cipher"></field>
        <field name="x509_issuer"></field>
        <field name="x509_subject"></field>
        <field name="max_questions">0</field>
        <field name="max_updates">0</field>
        <field name="max_connections">0</field>
        <field name="max_user_connections">0</field>
  </row>
</resultset>

posted @ 2009-11-04 11:48  window07  阅读(2026)  评论()    收藏  举报