Unsupported Screen Size: The viewport size is too small for the theme to render properly.

Xml Import

forums › forums › SQLyog › Using SQLyog › Xml Import

  • This topic is empty.
Viewing 3 reply threads
  • Author
    Posts
    • September 15, 2005 at 12:21 am #9226
      energylevel
      Member

      Can I import XML data into a MySQL table using SQLYog ?

      Thanks

    • September 15, 2005 at 12:50 am #19191
      peterlaursen
      Participant

      No, this option is not available.

      You can export to an XML-file but not import.

      To my best knowledge there no STANDARD for how data from a database table should be serialized to an XML-file. The XML standard describes formal issues such as use of tags and only that. The exact implementation of a XML data-file would be an open issue. (such as identifiers/names, headings/no hedings etc.)

    • December 6, 2005 at 12:39 am #19192
      emagin
      Member
      peterlaursen wrote on Sep 15 2005, 12:50 AM:
      To my best knowledge there no STANDARD for how data from a database table should be serialized to an XML-file.  The XML standard describes formal issues such as use of

      [post=”7176″]<{POST_SNAPBACK}>[/post]

      I haven't tested this, but it appears there are various ways to do this in MS Sql

      http://www.perfectxml.com/articles/xml/importxmlsql.asp

    • December 6, 2005 at 4:30 am #19193
      Ritesh
      Member

      This option is already in the TO-DO list though I cannot guarantee which version of SQLyog will have this option.

  • Author
    Posts
Viewing 3 reply threads
  • You must be logged in to reply to this topic.