Solved

loading data using sql loader in mysql?

Posted on 2008-10-21
4
2,136 Views
Last Modified: 2012-06-27
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
Comment
Question by:aej1973
  • 2
4 Comments
 
LVL 39

Accepted Solution

by:
Roger Baklund earned 100 total points
Comment Utility
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
 

Author Comment

by:aej1973
Comment Utility
ok, I will check this once I get to work tomorrow. Thx.
0
 
LVL 31

Expert Comment

by:awking00
Comment Utility
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
 

Author Closing Comment

by:aej1973
Comment Utility
Thank you, that woks.
0

Featured Post

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Join & Write a Comment

All XML, All the Time; More Fun MySQL Tidbits – Dynamically Generate XML via Stored Procedure in MySQL Extensible Markup Language (XML) and database systems, a marriage we are seeing more and more of.  So the topics of parsing and manipulating XM…
Introduction Since I wrote the original article about Handling Date and Time in PHP and MySQL (http://www.experts-exchange.com/articles/201/Handling-Date-and-Time-in-PHP-and-MySQL.html) several years ago, it seemed like now was a good time to updat…
Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the file…
This video shows how to remove a single email address from the Outlook 2010 Auto Suggestion memory. NOTE: For Outlook 2016 and 2013 perform the exact same steps. Open a new email: Click the New email button in Outlook. Start typing the address: …

743 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now