LOAD DATA INFLE (values problem)
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.
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.