Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2356
  • 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.

A
0
aej1973
Asked:
aej1973
  • 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.
0
 
aej1973Author Commented:
ok, I will check this once I get to work tomorrow. Thx.
0
 
awking00Commented:
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.
0
 
aej1973Author Commented:
Thank you, that woks.
0

Featured Post

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

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