Bluehost.com Web Hosting $6.95

importing nonprintable delimiters with mysql ?

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 ...


Go Back   Usenet Forums > Database Forums > MySQL Database

FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 01-30-2007
Jack
 
Posts: n/a
Default importing nonprintable delimiters with mysql ?

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

Reply With Quote
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are Off
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On




All times are GMT +1. The time now is 04:19 PM.


Powered by vBulletin® Version 3.7.3
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Content Relevant URLs by vBSEO 3.0.0