Re: help with load from file

[Martin Gainty]

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
> 
> 
> -- 
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    http://lists.mysql.com/mysql?unsub=1
> 
>