This is a discussion on importing nonprintable delimiters with mysql ? within the MySQL Database forums, part of the Database Forums category; Hi I was wondering if someone could reply with a command from the mysql client that I can issue which ...
|
|||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
|
|||
|
Hi I was wondering if someone could reply with a command from the
mysql client that I can issue which will import a flat file have 2 columns and a 034 octal (decimal 28, hex 1C) as the delimiting value. I have not been able to find a mysqlimport command that will work.. I tried this but no luck: mysqlimport instinct --fields-terminated-by= '1C' --fields-enclosed- by='\n' 'e:\TISS1b.txt'; Thanks, Jack |