Article:		Storing XML in Relational Databases
Subject:		Importing a Data Array from XML to DB
Date:		2007-08-21 04:00:59
From:		santoshlocuz
Response to: Importing a Data Array from XML to DB
hello dear, i created tree by using dom and 3xml files, i didnt used database interaction for retriving the data. i just simply uses my xml files .but i need to store these xml files in MY SQl database.? how?

Previous Message

Up

Next Message

• Importing a Data Array from XML to DB
  2007-08-21 19:26:35 Igor Dayen [Reply]
  
  You may consider:

  
  (a) using CLOBS if processing XML within a database is not significant; database is used as a storage and XML processing is delegated to application code;
  (b) using stored procedures as it suggested in http://rpbouman.blogspot.com/2006/03/importing-xml-data-into-mysql-using.html.

  
  
  MySQL team is considering to add XMLType support in future, see:
  http://forums.mysql.com/read.php?44,155525,157883#msg-157883

  
  Thank you.