0

Can I import data from a XML file into a table in SQL?

15th Jan 2016, 4:33 AM
Ennio Politi Lopes
Ennio Politi Lopes - avatar
2 Antworten
+ 2
You'll have to translate it into a flat file if you want the individual XML elements to transform into counterpart rows and columns of various tables. There are RDBMS out there that allow you to store XML or now even JSON as a data type, like integers or chars
28th Nov 2016, 10:08 AM
ViceKnightTA
ViceKnightTA - avatar
0
you could do it in Microsoft SQL .... probably you could do this with MySQL ....XML is a format for storing and delivering data and it can easily simulate a SQL table
20th Jan 2016, 10:42 PM
Reza Pouya