MySQL Forums
Forum List  »  Newbie

How can I run insert and load data for the same record (line)?
Posted by: Charles Carminati
Date: August 14, 2019 04:48PM

I need to run INSERT and LOAD DATA for the same record without creating a new line.

echo "INSERT INTO cds (cdnum,file) VALUES ('$data1','./$fileclean.TIF'); LOAD DATA LOCAL INFILE '/tmp/pdffile.txt' INTO TABLE cds LINES TERMINATED BY '\r\n' (ocr);"| mysql -uroot codata;

I need cdnum,file and ocr to be populated for the same record , right now it creates a new line for the LOAD DATA statement

Options: ReplyQuote


Subject
Written By
Posted
How can I run insert and load data for the same record (line)?
August 14, 2019 04:48PM


Sorry, you can't reply to this topic. It has been closed.
This forum is currently read only. You can not log in or make any changes. This is a temporary situation.

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.