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

Import A Csv

forums › forums › SQLyog › SQLyog: Bugs / Feature Requests › Import A Csv

  • This topic is empty.
Viewing 2 reply threads
  • Author
    Posts
    • March 18, 2006 at 8:40 pm #20917
      peterlaursen
      Participant

      About CSV import: http://www.webyog.com/faq/28_73_en.html

      the is considered an escape character, unless you change it. 'd' simply become 'd'. This is how MySQL Server treats the the escape character. Probably you don't need to use escape characters at all. Or you must use another character.

      There is a setting in the dialogue to skip 'n' number of lines.

    • March 19, 2006 at 12:19 am #20918
      rkardell
      Member

      Thanks. I had tried to go without the escape character, but it kept skipping the “” but when I changed it something irrelevent such as “+” it worked as it should.

      Thanks for the tip about skipping a number of lines.

    • March 19, 2006 at 12:40 am #20919
      peterlaursen
      Participant
      Quote:
      I had tried to go without the escape character, but it kept skipping the “”

      It looks like ” … escaped by ''” is default with a load infile staement. Maybe it could vary with different MySQL version.

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