title: XML/MySQL: Storing complete XML in MySQL and performing CRUD operations
body: <p>Is is possible to store directly complete XML file into MySQL db and perform CRUD operations on XML data present in MySQL ? </p>
  
  <p>Scenario: I am getting XML file which has product related details like product_id, product_spec, product_price and many more and I have to store all this details into MySQL database and whenever user enter portal he selects for particular product from the product catalog and depending upon his selection shopping cart is populated i.e, depending upon user's selection shopping cart performs read operation on MySQL db to get the relevant data for the product, as an aside XML file which I am getting from 3rd party is very large as it has millions of products with all relevant details. </p>
  
  <p>If it is possible than what are ways to do it ?</p>
  
  <p>I'd appreciate guidance. </p>