LOAD XML Syntax [v5.5]

호~ 괜찮은데... xml loader...

LOAD XML [LOW_PRIORITY | CONCURRENT] [LOCAL] INFILE 'file_name'
[REPLACE | IGNORE]
INTO TABLE [db_name.]tbl_name
[CHARACTER SET charset_name]
[ROWS IDENTIFIED BY '<tagname>']
[IGNORE number [LINES | ROWS]]
[(column_or_user_var,...)]
[SET col_name = expr,...]

* 명령어들
shell> mysql --xml -e 'SELECT * FROM mytable' > file.xml

mysql> LOAD XML LOCAL INFILE 'person-dump.xml' INTO TABLE person2;

mysql> LOAD XML LOCAL INFILE 'address.xml'
    ->   INTO TABLE person
    ->   ROWS IDENTIFIED BY '<person>';

http://dev.mysql.com/doc/refman/5.5/en/load-xml.html