I have a one time load of an extremely large file. It's a tab delimited
file, the problem I'm getting is importing the following field.
C:\Borland\server\bin\gbak.exe - The field how it looks on the import
file (it's delimited by tabs)
C:Borlandserver ingbak.exe - How it looks once it is imported into
MySql
Between the "ver ing" there is a tab
character that I can't get to show on this e-mail
I think it's
interpreting the \b (from server\bin) as a tab character or something.
Without editing the entire file how can I get around this problem? I would
also like to see the '\' in the database if possible.
Following is the load statement that I am using for loading the data.
load data local infile "e:/data_in/keyaudit.kau" into table tbl_KeyAudit;
MySql version is 3.23.28-gamma-debug
Debra Samsom
Bristol Aerospace Ltd.
(204) 775-8331 3402
[EMAIL PROTECTED]
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
