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

Importing csv error

forums › forums › SQLyog › Using SQLyog › Importing csv error

  • This topic is empty.
Viewing 2 reply threads
  • Author
    Posts
    • May 31, 2003 at 7:42 pm #7990
      Dan1
      Member

      hi

      Error No 1064

      You have an error in your sql syntax. Check the manual corresponds to your mysql server version for the right syntax to use near 'name, address, age,location, etc etc

      I keep getting this message everytime i try to import my csv file. Im using mysql4.0.

      Anyone had the same problem?

      TIA

    • June 1, 2003 at 1:48 pm #14431
      Ritesh
      Member

      Are you using SQLyog's Import CSV option? All the queries executed by SQLyog are listed in the History tab. Can you paste the query out here so that we can figure out where the error is?

    • June 6, 2003 at 4:28 pm #14432
      peterlaursen
      Participant

      and also important ..

      What is the filed delimitter in that .csv-file and eol-character ? You can choose corresponding values during import.

      What program wrote the .csv file ?

      Several programs (Excel for instance) can only write DOS-text, so if there are non-english national characters (ö, æ ñ) that could cause all sorts of problems …

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