MySQL Forums
Forum List  »  Newbie

LOAD DATA INFLE (values problem)
Posted by: Kaiser Cole
Date: April 18, 2005 11:59AM

Dear members, I have really stucked with one problem. I have a table with the following fields:

id users_id first_name last_name

what I need is to insert the information from the following statment:

load data LOCAL infile '$upload_file' into table temp_".$res['users_id']."
fields terminated by ',' optionally ENCLOSED BY '\"' lines terminated by '\r\n' ignore 1 lines

This infile has only to fields: first_name and last_name. But in my table I have to also include users_id value. How can I do that with the statement above? Thnaks forehand.

Options: ReplyQuote


Subject
Written By
Posted
LOAD DATA INFLE (values problem)
April 18, 2005 11:59AM


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.