MySQL Forums
Forum List  »  Connector/Node.js

Advanced Search
New Topic

Re: How to store entire xml file into mysql db
Posted by: Harald Groven
Date: July 09, 2009 01:34PM

Use
LOAD DATA INFILE ... LINES TERMINATED BY '</endTag>'

if you are on MySql 4+ or LOAD XML if you are on MySql 6.

I have posted an example on how to do it as a user comment in
http://dev.mysql.com/doc/refman/6.0/en/load-xml.html

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Written By
Posted
How to store entire xml file into mysql db
vijay reddy
May 11, 2009 11:44PM
Re: How to store entire xml file into mysql db
neonle lee
June 19, 2009 10:20PM
Re: How to store entire xml file into mysql db
Harald Groven
July 09, 2009 01:34PM
How to store entire xml file in a single table
anthony lamadrid
September 16, 2009 10:09PM
How to store entire xml file in a single table
monopoly monopoly
October 07, 2009 06:13AM
Re: How to store entire xml file into mysql db
Clifford Max
November 05, 2009 10:30AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.