distal-attribute
distal-attribute
distal-attribute
distal-attribute

CSV import

User, date Message
Written by juyles
3 years ago
Category: Import/Export
3 posts since Mon, 26 Sep 11
I am trying import a csv file from a utf-8 wordpress database.
I get the first 3 lines in OK, one record. The other following
records are not imported.

My question is in the 'import text field' window what should
be contained in the window 'lines terminated by'.

I have looked for a symbol reference that would help me with
this information, but so far no luck. I am new to heidi.

Would appreciate any guidance or direction. Thanks

Juyles
Written by ansgar
3 years ago
4940 posts since Fri, 07 Apr 06
See http://dev.mysql.com/doc/refman/5.1/en/load-data.html

Character Escape Sequence
\0 An ASCII NUL (0x00) character
\b A backspace character
\n A newline (linefeed) character
\r A carriage return character
\t A tab character.
\Z ASCII 26 (Control+Z)
\N NULL
Written by juyles
3 years ago
3 posts since Mon, 26 Sep 11
Thank you very much!

Juyles
 

Please login to leave a reply, or register at first.