Re: help with load from file

[trogers]

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