• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2446
  • Last Modified:

loading data using sql loader in mysql?

Hi , I have a table that contains some data. I loaded this table using sql loader and used the following script;

load data infile 'c:/channel_lineups/load/all_code.txt 'into table `channel` (channel_id, channel_name, satellite);

Now I need to add more data to this table without deleting the existing data. How do I do this using sql loader? Thank you for the help.

  • 2
1 Solution
Roger BaklundCommented:
You can use the same script, existing data will not be deleted by the load data infile statement. It must of course only contain new data, it will not update old records.
aej1973Author Commented:
ok, I will check this once I get to work tomorrow. Thx.
I'm not familiar with using sql loader for MySQL, thought it was an Oracle utility. In Oracle, you can include the APPEND keyword to add records to a table. Perhaps that is the same for MySQL.
aej1973Author Commented:
Thank you, that woks.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Train for your Pen Testing Engineer Certification

Enroll today in this bundle of courses to gain experience in the logistics of pen testing, Linux fundamentals, vulnerability assessments, detecting live systems, and more! This series, valued at $3,000, is free for Premium members, Team Accounts, and Qualified Experts.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now