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

Importing A Simple Csv File

forums › forums › SQLyog › Using SQLyog › Importing A Simple Csv File

  • This topic is empty.
Viewing 0 reply threads
  • Author
    Posts
    • May 14, 2012 at 5:12 pm #12666
      terrymold
      Member

      Hi all

      I have been trying all day to get SQLyog to import a simple csv file into a MySQL table.The first 3 fields are text (varChar), but quite a few of them, about 300 or so, contain one or more minus characters “-“. And for each of those records, SQLyog gives an arror, the latest error being “Warning Error 1366: Incorrect string value”. Earlier errors were 1265 and 1261. The last one (1366) resulted from me enclosing the text in the first three fields in “.

      Here is an actual record… “Knokke–Heist”,,”Belgium”,51.35000,3.28333

      Is this a common problem? Or am I doing something wrong?

      Any kind of solution would be very welcome.

      Thanks

      Terry

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