From: Date: April 23 2005 1:07am
Subject: MySQL to XML
List-Archive: http://lists.mysql.com/mysql/182995
Message-Id: <BAY9-F842686217FB2CE67A22C5A52D0@phx.gbl>
MIME-Version: 1.0
Content-Type: text/plain; format=flowed

Hi list, does it possible for MySQL to generate XML in the followin format:

<table name="ServiceType">
    <column name="idTipoServicio" primaryKey="true"
            required="true" type="VARCHAR" size="10"/>
    <column name="nombre" required="true" type="VARCHAR" size="255"/>
    <column name="costo" required="true" type="FLOAT" size="9"/>
    <column name="idGrupo" required="true" type="INTEGER"/>
    <column name="activa" required="true" type="BOOLEANINT"/>

    <foreign-key foreignTable="Grupo" onUpdate="none" onDelete="none">
        <reference foreign="idGrupo" local="idGrupo"/>
    </foreign-key>
  </table>

This XML is the structure of the ServiceType table,  I'll hope that you can 
help me

Thnx in advanced

Greetings

P.S. Any suggestions (tools) will be appreciated