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

Lame Newbie Import CSV Question

forums › forums › SQLyog › Using SQLyog › Lame Newbie Import CSV Question

  • This topic is empty.
Viewing 1 reply thread
  • Author
    Posts
    • April 23, 2003 at 6:12 pm #14116
      Ritesh
      Member

      Hello

      Make sure that you are giving the correct escape sequence characters in SQLyog.

      HTH

    • May 13, 2003 at 6:08 pm #14117
      Titom
      Member

      Hi,

      By default, in SQLyog, the column separator for your CSV file is tab “t”, Excel uses a comma “,” so SQLyog may consider your row as a record if it doesn't found any comma… This could explain that it fill the other columns with NULL.

      Maybe you should change it in the CSV Import dialog box (“Change…” button).

      Titom.

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