help with load from file

[trogers]

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/[EMAIL PROTECTED]