Using WinMySQL Professional

Save output to XML file

Only accessible when connected, this feature is designed to allow users to easily write HTML pages of their query results.

Indeed, in two mouse clicks, the output grid content is exported to an xml compliant datafile with a trivial DTD. Then, it will be possible to transfer these data, writing a regular processing program to insert these data to any other DataBase Management System such as Oracle®.

To do, simply invoke the «Output grid>Save output to XML» submenu. Then, enter a filename (default extension is «XML»).

The DTD describes the datafile structure as :

<output>
  <data rowid=«1»>
    <column_1_name>
      ... Data ...
    </column_1_name>
  </data>

(...)

  <data rowid=«n»>
    <column_n_name>
      ... Data ...
    </column_n_name>
  </data>
</output>