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

Export Resultset->CSV inconsistency

forums forums SQLyog SQLyog Comments Export Resultset->CSV inconsistency

  • This topic is empty.
Viewing 1 reply thread
  • Author
    Posts
    • #7802
      Anonymous
      Guest

      Before I begin, kudos to you on such a wonderful app, thank you.

      I do a lot of data extracts to CSV and have come across a bit of an inconsistency. If I choose to export a resultset as CSV and change how the fields are delimited and separated (eg fields enclosed by ” and terminated by ,) and check 'Add Column Names On Top', all the fields are delimited/separated fine however the column headings don't seem to be delimited (in about case by “).

    • #14016
      Ritesh
      Member

      It is a known feature.

      While importing data just use the IGNORE n LINES command to ignore the column headings 🙂

Viewing 1 reply thread
  • You must be logged in to reply to this topic.