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 2 reply threads
  • Author
    Posts
    • April 22, 2003 at 9:02 pm #7858
      squidlor
      Member

      Help!

      I am taking an internet programming course, and I am stuck. I want to create a page that queries a mysql database, but I can not figure out how to import my excel csv file as a mysql table. I have installed SQLyog, and have been able to create a test table and tried a test import. Basically, it seems like I can import the first column of data, but I end up with NULL in all of the other cells.

      Could anybody walk me through the csv import process or direct me to a website that has the right information. Thank you.

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