1 <?xml version="1.0"?>
    2 <mysqldump xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
    3    <database name="db1_9">
    4       <table_structure name="student">
    5          <field Field="snum" Type="int(9)" Null="" Key="PRI" Default="0" Extra="" />
    6          <field Field="sname" Type="varchar(30)" Null="YES" Key="MUL" Extra="" />
    7          <field Field="major" Type="varchar(25)" Null="YES" Key="MUL" Extra="" />
    8          <field Field="standing" Type="char(2)" Null="YES" Key="" Extra="" />
    9          <field Field="age" Type="decimal(3,0)" Null="YES" Key="" Extra="" />
   10          <key Table="student" Non_unique="0" Key_name="PRIMARY" Seq_in_index="1" Column_name="snum"
   11             Collation="A" Cardinality="24" Null="" Index_type="BTREE" Comment="" />
   12          <key Table="student" Non_unique="1" Key_name="part_stu_name" Seq_in_index="1"
   13             Column_name="sname" Collation="A" Sub_part="5" Null="YES" Index_type="BTREE" Comment="" />
   14          <key Table="student" Non_unique="1" Key_name="full_major" Seq_in_index="1"
   15             Column_name="major" Null="YES" Index_type="FULLTEXT" Comment="" />
   16          <options Name="student" Engine="MyISAM" Version="9" Row_format="Dynamic" Rows="24"
   17             Avg_row_length="43" Data_length="1040" Max_data_length="4294967295" Index_length="4096"
   18             Data_free="0" Create_time="2006-10-02 15:37:28" Update_time="2006-10-02 15:37:28"
   19             Collation="latin1_swedish_ci" Create_options="" Comment="" />
   20       </table_structure>
   21       <table_data name="student">
   22          <row>
   23             <field name="snum">51135593</field>
   24             <field name="sname">Maria White</field>
   25             <field name="major">English</field>
   26             <field name="standing">SR</field>
   27             <field name="age">21</field>
   28          </row>
   29          <row>
   30             <field name="snum">60839453</field>
   31             <field name="sname">Charles Harris</field>
   32             <field name="major">Architecture</field>
   33             <field name="standing">SR</field>
   34             <field name="age">22</field>
   35          </row>
   36          <row>
   37             <field name="snum">99354543</field>
   38             <field name="sname">Susan Martin</field>
   39             <field name="major">Law</field>
   40             <field name="standing">JR</field>
   41             <field name="age">20</field>
   42          </row>
   43          <row>
   44             <field name="snum">112348546</field>
   45             <field name="sname">Joseph Thompson</field>
   46             <field name="major">Computer Science</field>
   47             <field name="standing">SO</field>
   48             <field name="age">19</field>
   49          </row>
   50          <row>
   51             <field name="snum">115987938</field>
   52             <field name="sname">Christopher Garcia</field>
   53             <field name="major">Computer Scienc
   54 e</field>
   55             <field name="standing">JR</field>
   56             <field name="age">20</field>
   57          </row>
   58          <row>
   59             <field name="snum">132977562</field>
   60             <field name="sname">Angela Martinez</field>
   61             <field name="major">History</field>
   62             <field name="standing">SR</field>
   63             <field name="age">20</field>
   64          </row>
   65          <row>
   66             <field name="snum">269734834</field>
   67             <field name="sname">Thomas Robinson</field>
   68             <field name="major">Psychology</field>
   69             <field name="standing">SO</field>
   70             <field name="age">18</field>
   71          </row>
   72          <row>
   73             <field name="snum">280158572</field>
   74             <field name="sname">Margaret Clark</field>
   75             <field name="major">Animal Science</field>
   76             <field name="standing">F
   77 </field>
   78             <field name="age">18</field>
   79          </row>
   80          <row>
   81             <field name="snum">301221823</field>
   82             <field name="sname">Juan Rodriguez</field>
   83             <field name="major">Psychology</field>
   84             <field name="standing">JR</field>
   85             <field name="age">20</field>
   86          </row>
   87          <row>
   88             <field name="snum">318548912</field>
   89             <field name="sname">Dorthy Lewis</field>
   90             <field name="major">Finance</field>
   91