Examples for business, study, careers, love, and more...
Examples :: MYSQL Examples :: Example of Load XML MYSQL Statement

Example of Load XML MYSQL Statement

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

Example of Mysql Load XML


LOAD XML LOCAL INFILE 'c:/users/ryan/desktop/3.xml'