 |
ometimes you need to insert new data and update existing data to relational tables during a bulk import of a physical file. You can accomplish this type of insert or update activity using a MERGE statement in Oracle and a REPLACE INTO statement in MySQL. MySQL also supports a merge operation with the ON DUPLICATE KEY clause of the INSERT statement (introduced in Chapter 7). This chapter covers these statements as methods for merging data in Oracle and MySQL. |
Data import files often present interesting challenges, because they frequently contain ...
Get Oracle Database 11g & MySQL 5.6 Developer Handbook now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
