Forums | Webyog
Tools to manage and monitor MySQL databases
forums › forums › SQLyog › Using SQLyog › Importing a csv into a table
Yes.
Instead of specifying rn as line terminators, you should have specified n.
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!!!
Can you mail me the CSV file and the table structure if the data is not confidential?
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','');