Hi.
I have the following command:
mysqlimport -d -c, --columns=DATE,TIME,MSG --fields-terminated-by=,
--fields-enclosed-by=, dbase c:\file.txt
This reads the following from a text file:
26 Sep 2001, 05:42:24 : Text message to be read.
The date and time separator is a "," and the time and message separator
is a ":" But the time field is also split up with ":" where as I don't
want to split up the time field.
Does anybody have any suggestions on how I can overcome this problem?
Charles Lewis
HAS Configuration Specialist
Oxford Technology Solutions Ltd.
The Technology Centre
213, Barns Road
Oxford OX4 3UT
United Kingdom
Company Number: 3610219
T: +44 (0) 1865 785 341
F: +44 (0) 1865 777 080
M: +44 (0) 7870 630514
E: [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>
W: http://www.ots-uk.com <http://www.ots-uk.com/>
The information in this message is confidential and may be legally privileged. It is
intended solely for the addressee. Access to this message by anyone else is
unauthorised. If you are not the intended recipient, any disclosure, copying,
distribution or any action taken or omitted to be taken in reliance on it, is
prohibited and may be unlawful.
Any attachment(s) to this message has been checked for viruses, but please rely on
your own virus checker and procedures.
---------------------------------------------------------------------
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
