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
    • April 3, 2003 at 11:04 am #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 “).

    • April 3, 2003 at 1:38 pm #14016
      Ritesh
      Member

      It is a known feature.

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

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