lt;[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, November 01, 2004 9:52 PM
Subject: Disincluding columns when using load data
I've checked through the archives a documentation but cannot find an
answer to my problem. I'm attempting to load data from a text file
that h
Hi.
You may use lines starting by '\t' to ignore first column (if your outfile has default
format).
For example:
select * from t4;
+--+--+--+--+
| a| b| c| d|
+--+--+--+--+
|1 |2 |3 |4 |
|2 |6 |7 |4 |
|
I've checked through the archives a documentation but cannot find an
answer to my problem. I'm attempting to load data from a text file
that has a column that is not present in my database table.
Table
B C D
File
A B C D
I've been trying to find a way to ignore the first column of the text
file