MySQL Forums
Forum List  »  General

Importing selected columns from a text file
Posted by: Timothy Brooks
Date: February 20, 2005 07:10AM

I have a comma-delimited text file with 99 columns. I only need about 25 of them, and the ones I need are scattered among the 99. On a nightly basis, I'll be retrieving the file by FTP and then importing the data. I'm working in PHP.

I assume I want to use LOAD DATA INFILE. But how do I tell it that I only want certain columns?

Options: ReplyQuote


Subject
Written By
Posted
Importing selected columns from a text file
February 20, 2005 07:10AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.