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
Charles Lewis writes:
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
Hi Charles!
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.
Carl's response was perfect end negated my
Hi Charles,
- Original Message -
From: Charles Lewis [EMAIL PROTECTED]
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