How To Return Query Output in XML Format

Q

How To Return Query Output in XML Format? - MySQL FAQs - Command-Line End User Interface mysql

✍: FYIcenter.com

A

By default, "mysql" returns query output in text table format. If you want to receive query output in XML format, you need to use the "-X" command option. Here is a good tutorial exercise:

>cd \mysql\bin
>mysql -u root -X test

mysql> SELECT * FROM links;
<?xml version="1.0"?>
<resultset statement="SELECT * FROM links">
  <row>
        <field name="id">1</field>
        <field name="name">dba.fyicenter.com</field>
  </row>
  <row>
        <field name="id">10</field>
        <field name="name">dba.fyicenter.com</field>
  </row>
</resultset>
2 rows in set (0.00 sec)

2007-05-10, 4715👍, 0💬

What Is Table
What Is Table? - MySQL FAQs - Database Basics and Terminologies A table is a data storage structure with rows and columns. 2007-05-10, 5163👍, 0💬

What Is Column
What Is Column? - MySQL FAQs - Database Basics and Terminologies A column defines one piece of data stored in all rows of the table. 2007-05-10, 5093👍, 0💬

What Is mSQL
What Is mSQL? - MySQL FAQs - Database Basics and Terminologies Mini SQL (mSQL) is a light weight relational database management system capable of providing rapid access to your data with very little overhead. mSQL is developed by Hughes Technologies Pty Ltd. MySQL was started from mSQL and shared th... 2007-05-10, 4825👍, 0💬

What Is MySQL
What Is MySQL? - MySQL FAQs - Database Basics and Terminologies MySQL is an open source database management system developed by MySQL AB, http://www.mysql.com. 2007-05-10, 4804👍, 0💬

What Are the Non-Standard SQL Commands Supported by "mysql"
What Are the Non-Standard SQL Commands Supported by "mysql"? - MySQL FAQs - Command-Line End User Interface mysql There are many non-standard SQL commands that are supported by "mysql". Here is short list of some commonly used commands: "SHOW infoName" - Shows basic information of based on the speci... 2007-05-10, 4780👍, 0💬

How To Return Query Output in XML Format
How To Return Query Output in XML Format? - MySQL FAQs - Command-Line End User Interface mysql By default, "mysql" returns query output in text table format. If you want to receive query output in XML format, you need to use the "-X" command option. Here is a good tutorial exercise: >cd \mysql\bin >... 2007-05-10, 4716👍, 0💬

How To Return Query Output in HTML Format
How To Return Query Output in HTML Format? - MySQL FAQs - Command-Line End User Interface mysql By default, "mysql" returns query output in text table format. If you want to receive query output in HTML format, you need to use the "-H" command option. Here is a good tutorial exercise: >cd \mysql\bin... 2007-05-10, 4711👍, 0💬

How To Get Help Information from the Server
How To Get Help Information from the Server? - MySQL FAQs - Command-Line End User Interface mysql While you are at the "mysql>" prompt, you can get help information from the server by using the "HELP" command. The tutorial exercise below shows sevearal examples: >cd \mysql\bin >mysql -u root mysql> ... 2007-05-10, 4670👍, 0💬

What Is SQL
What Is SQL? - MySQL FAQs - Database Basics and Terminologies SQL, SEQUEL (Structured English Query Language), is a language for RDBMS (Relational Database Management Systems). SQL was developed by IBM Corporation. 2007-05-10, 4618👍, 0💬

All rights in the contents of this web site are reserved by the individual author. fyicenter.com does not guarantee the truthfulness, accuracy, or reliability of any contents.