Import schema for MySql

Hi,

I am trying to import an XML file to a table in MySQL, but am getting an error with the schema. How do I determine from looking at the XML file what the schema for the database table should be?

The XML file is listed below -

<?xml version="1.0" encoding="ISO-8859-1"?>

<xport>
<meta>
<start>1064841900</start>
<step>300</step>
<end>1064928600</end>
<rows>290</rows>
<columns>2</columns>
<legend>
<entry>Tx from Cust</entry>
<entry>Rx to Cust</entry>
</legend>
</meta>
<data>
<row><t>1064844300</t><v>4.8531558687e+003</v><v>1.1178867326e+004</v></row>
<row><t>1064844600</t><v>5.3744500273e+003</v><v>1.4437013410e+004</v></row>
<row><t>1064844900</t><v>5.3086930676e+003</v><v>1.4960800753e+004</v></row>
<row><t>1064845200</t><v>5.1178093355e+003</v><v>1.3331975748e+004</v></row>
</data>
</xport>


Thx
SiRiC

That's rather confusing. It says there are two columns, but each row has three entries. Where did you get the xml file? You may be able to ask whoever you got it from to explain it.