|
Posted by Carl Pearson on January 30, 2007, 8:30 am
Please log in for more thread options
Jack wrote:
> 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
>
Try doing it directly from the mysql prompt with 'load data infile':
http://dev.mysql.com/doc/refman/4.1/en/load-data.html
| 
XML Sitemap