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

import csv question

forums forums SQLyog Using SQLyog import csv question

  • This topic is empty.
Viewing 2 reply threads
  • Author
    Posts
    • #13744
      Ritesh
      Member

      Can you give me more information about how the fields are terminated/enclosed etc.

    • #13745
      cseelig
      Member

      The file is an ordinary Windows/DOS text file.

      Lines are delimited by a carriage-return/line-feed pair.

      Fields (columns) are delimited by a tab character.

      Fields are not further enclosed (no quotes around text fields, for example).

      It appears that, in the mode in which I'm using the import facility,

      the utility is expecting a Unix-style text file, in which fields are

      delimited by a single character (line feed?).

      Thanks.

    • #13746
      Ritesh
      Member

      Hope the configuration shown in the image below will help you.

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