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

Exporting Mysql Table To Csv

forums › forums › SQLyog › Using SQLyog › Exporting Mysql Table To Csv

  • This topic is empty.
Viewing 1 reply thread
  • Author
    Posts
    • November 14, 2011 at 12:07 am #12500
      Jhmmy
      Member

      Hi all!

      I am new to MySQL…I am trying to export the data of a table to csv. The settings I use for exporting are:

      Escaped by:

      Lines terminated by: rn

      Variable length:

      Fields terminated by: ,

      Fields enclosed by: ” Optionally

      The problem is that some of my fields contain data with “, e.g. The place of the meeting is at “Plaza hotel”. This “corrupts” the data and the fields are not shown as they should be. Is there a way I can fix this?

      Thank you very much!

    • November 14, 2011 at 6:04 am #32839
      ashwin
      Member

      Hello,

      Quote:
      The problem is that some of my fields contain data with “, e.g. The place of the meeting is at “Plaza hotel”. This “corrupts” the data and the fields are not shown as they should be. Is there a way I can fix this?

      When using a “”” inside a string the enclosed character(Escaped by) must be specified as “””(Double quote) itself. Please refer MySQL documentation: http://dev.mysql.com/doc/refman/5.0/en/string-syntax.html#character-escape-sequences

      Regards,

      Ashwin A

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