This project implements a doctype for representing a MySQL table in XML. From this point, it is possible to do a number of translations. I have implemented three XSLT transformations: a description view of the table, a SQL CREATE TABLE generator, and an automatic form generation view. The form will actually process your input and show you the SQL statement needed to insert it into a database. Due to permission problems, it was not possible to make this fully implemented.

Check out the DTD for this doctype here: mysqltable.dtd. You may have to do "view source" in your browser in order to see it. You may want to read more about my design decisions with this doctype.


Below are some example XML files which implement this doctype. There are several translations of these documents as well.


This page is valid XHTML 1.0 Strict.