importing nonprintable delimiters with mysql ?

[Jack]

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

[Carl Pearson]

Post by Jack
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
mysqlimport instinct --fields-terminated-by= '1C' --fields-enclosed-
by='\n' 'e:\TISS1b.txt';
Thanks,
Jack

Try doing it directly from the mysql prompt with 'load data infile':

http://dev.mysql.com/doc/refman/4.1/en/load-data.html