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

Importing a csv into a table

forums › forums › SQLyog › Using SQLyog › Importing a csv into a table

  • This topic is empty.
Viewing 3 reply threads
  • Author
    Posts
    • February 8, 2005 at 12:41 pm #16957
      Ritesh
      Member
      Quote:
      Was it possible to set the YOG import wizard to recognise the unix file format?

      Yes.

      Instead of specifying rn as line terminators, you should have specified n.

    • February 8, 2005 at 12:59 pm #16958
      zzapper
      Member

      Ritesh,

      I tried alternatively r and n w/o success.

      The query I tried to use to clean up the data was

      update tbl_county_lookup set countyname=replace(countyname,'&','and');

      That works for a character such as '&' but I couldn't get it to work for null where I tried N and NULL.

      Come on folks this must be a fairly common problem!!!

    • February 8, 2005 at 5:10 pm #16959
      Ritesh
      Member

      Can you mail me the CSV file and the table structure if the data is not confidential?

    • February 11, 2005 at 1:57 pm #16960
      zzapper
      Member

      Ritesh,

      Sorry was me having a bad-hair day.

      The csv line terminator I required was rn

      Non-ascii characters inserted into mysql all seem to display as a hollow box

      The mysql I needed to filter it out (having got the line terminator wrong) was

      update test set txt = replace(txt,'r','');

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