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 3 reply threads
  • Author
    Posts
    • March 18, 2006 at 5:33 pm #9547
      rkardell
      Member

      I am trying to import a CSV that is full of file path names, e.g. docmydocumentsfile. When I import this structure, the “” are removed. Why is this happening? I have tried several different variations in the import table dialog box, but have not had success. Can anyone help?

      Also, is there a way to designated the first row as a header row and not import it?

      Thanks,

      Bob

    • 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 3 reply threads
  • You must be logged in to reply to this topic.