473,320 Members | 2,147 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

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

Jan 30 '07 #1
1 2680
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
Jan 30 '07 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

20
by: de Beers | last post by:
mysql_query("DELETE FROM cart WHERE ItemId=$ItemId"); There is the code but the result in my databse is that the ID number changes from, lets say, 77 to 78 with 78's contents being empty. ...
0
by: Campbell's List | last post by:
Hi, I'm completely new to MySql and need help importing tables from Access or Dbase. I am using Dreamweaver MX to create a data-driven web site. With the VPS hosting plan we're on, our remote...
18
by: Ian Davies | last post by:
Hello Apologies for posting to so many groups but this one is difficult to catagorize precisely The following code worked fine with a connection to an Access database. However, I have changed...
2
by: PaulR | last post by:
Hi, We seem to have encountered a bug(or working as deigned?) in the import utility on 8.2 LUW. We are using the standard column and char delimiters of , and " while loading files of type...
0
by: samershqair | last post by:
Hello everybody, can you tell me please if there is an equivalent MySQL built-in procedure to: SQL built-in : sp_xml_preparedocument and SQL built-in : sp_xml_removedocument and SQL...
1
by: holdingbe | last post by:
Hi, I try to importing mysqk dumps into database i got error like ERROR 1045 (28000): Access denied for user How to avoid this?
2
by: Alan M Dunsmuir | last post by:
A client has sent me a (Windows) Excel Spreadsheet (.xls) file containing a block of data he wants included as a table in a MySQL database in a (Linux-based) PHP/MySQL Web application I'm...
2
by: runway27 | last post by:
hi i need to import data into a table in mysql from phpmyadmin using the Import option instead of using insert statements. for example if the table has 10 fields should the file that needs to...
6
by: ronparker | last post by:
Hello, This is my first time posting and just my second day using python on mysql, so please be patient with me. I should also say, I am using a linux machine. Using python I was able to make a...
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.