Company Database

 <COMPANY>

    <EMPLOYEE>

        <EMPNO>121</EMPNO>

        <EMPNAME>SEGAR</EMPNAME>

        <POSITION>MANAGER</POSITION>

    </EMPLOYEE>

    <EMPLOYEE>

        <EMPNO>122</EMPNO>

        <EMPNAME>MUKESH</EMPNAME>

        <POSITION>OFFICE</POSITION>

    </EMPLOYEE>

    <EMPLOYEE>

        <EMPNO>123</EMPNO>

        <EMPNAME>ARUL</EMPNAME>

        <POSITION>PUNE</POSITION>

    </EMPLOYEE>

</COMPANY>

CREATE TABLE MYTABLE (

    EMPNO INT NOT NULL,

    EMPNAME VARCHAR(45) NULL,

    POSITION VARCHAR(45) NULL,

    PRIMARY KEY (EMPNO)

);

LOAD XML INFILE 'D:/Segar/db.xml'

INTO TABLE MYTABLE

ROWS IDENTIFIED BY '<EMPLOYEE>';