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: <[EMAIL PROTECTED]> To: "MySQL List" <[EMAIL PROTECTED]> 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/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
