Data Formats and XML Support

Topics 

  • Exporting records 
  • Importing records 
  • Starting MySQL client with “--xml” option 
  • Reading XML file
  • XPath tutorial 
  • XML functions
    • ExtractValue(..) 
    • UpdateXML(..) 
  • Exporting a table to an XML file 
  • XML support in MySQL 6.0

Exporting Records into a File 

  • Use SELECT statement with INTO OUTFILE (nonbinary data) or INTO DUMPFILE for (binary data - contents of BLOB fields)
  • Field termination through FIELDS TERMINATED 
  • Line termination through LINES TERMINATED

You must have an active subscription to download PDF and Lab Zip of this course topic.Please click the "Subscribe" button or the "Login" button if you already have an account.