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: <[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
