How to import XML file into MySQL database table using XML_LOAD(); function

by

you can specify fields like this:

LOAD XML LOCAL INFILE '/pathtofile/file.xml' 
INTO TABLE my_tablename(personal_number, firstname, ...);

More Related Contents:

  1. How do I import an SQL file using the command line in MySQL?
  2. Import data in MySQL from a CSV file using LOAD DATA INFILE
  3. How to import a CSV file into a MySQL table
  4. How to import data from text file to mysql database
  5. Migrate from Oracle to MySQL
  6. Import SQL file into mysql
  7. How can I correct MySQL Load Error
  8. How to Import Multiple csv files into a MySQL Database
  9. How can I import a database with MySQL from terminal?
  10. ERROR 1148: The used command is not allowed with this MySQL version
  11. Import CSV to Update only one column in table
  12. How I can Import data from CSV to MySQL?
  13. Import CSV to Update rows in table
  14. How to import a csv file into MySQL workbench?
  15. “INSERT IGNORE” vs “INSERT … ON DUPLICATE KEY UPDATE”
  16. Count the occurrences of DISTINCT values
  17. Column count doesn’t match value count at row 1
  18. How to search JSON data in MySQL?
  19. MySQL > Table doesn’t exist. But it does (or it should)
  20. How do I modify a MySQL column to allow NULL?
  21. Connect to mysql in a docker container from the host
  22. Change decimal separator in MySQL
  23. How to skip certain database tables with mysqldump?
  24. Using MySql with Entity Framework 4 and the Code-First Development CTP
  25. MySQL treats ÅÄÖ as AAO?
  26. MySQL Time Zones
  27. mysql_fetch_row() vs mysql_fetch_assoc() vs mysql_fetch_array() [duplicate]
  28. Mysql select where not in table
  29. Which DATATYPE is better to use TEXT or VARCHAR?
  30. Are there any functions in MySQL like dense_rank() and row_number() like Oracle?

Leave a Comment