Yes, I simply don't understand this:
===========
LOAD DATA [LOW_PRIORITY | CONCURRENT] [LOCAL] INFILE 'file_name.txt'
[REPLACE | IGNORE]
INTO TABLE tbl_name
[FIELDS
[TERMINATED BY '\t']
[[OPTIONALLY] ENCLOSED BY '']
[ESCAPED BY '\\' ]
]
[LINES
[STARTING BY '']
[TERMINATED BY '\n']
]
[IGNORE number LINES]
[(col_name,...)]
==============
Help?
Ted
On Tuesday, May 27, 2003, at 09:35 PM, Martin Gainty wrote:
> Ted-
> check out
> http://www.mysql.com/doc/en/LOAD_DATA.html
> (go to mysql prompt and issue command LOAD DATA INFILE)
> keeping attention to format for INFILE
> Hth,
> Martin
> ----- Original Message -----
> From: <trogers@stripped>
> To: "MySQL List" <mysql@stripped>
> Sent: Tuesday, May 27, 2003 9:25 PM
> Subject: help with load from file
>
>
>> Hi,
>>
>> I have a text file where lines look like this:
>>
>> 3 Mac Performa6300CD 338211 LOV 109 \ \ \
>> 4 Mac G3BT/266 350755 LOV 003 \ 9.1 104.103
>>
>> Except they are not wrapped like in this email!
>> Each column is separated by a 'tab' (at least I think so).
>> The "\" character represents data I don't know (null).
>>
>> I have created a db and a table where I would like to upload the data;
>> the table has 9 filelds; the data in the rows, like row 3 and row 4
>> above (3 & 4 is also part of the data, the record_id), are in the same
>> order as the fields occur in the table. The table fields are setup
>> with types and so on.
>>
>> How do I get this data in there? I think I am missing somethings?
>> (I'm trying to do it with phpMyAdmin but I can do it from CLI if
>> someone would be so kind as to show me?)
>>
>> Thank you,
>> Ted
