How to create SQL script exporting from DB with UPDATES querys?
Hi there!
I'm Newbie here, i have a complete DB with some tables with lots of data, in each table i want to export a SQL file (2 columns of 6) with UPDATES statement. When i want to use that SQL file in another computer i want to UPDATE and not INSERT INTO or REPLACE script.
I want my SQL exported file as: (example)
UPDATE `game_tele` SET `name`='BarrancoPlumaPolvorienta' WHERE `id`='314';
UPDATE `game_tele` SET `name`='VallePolvofuego' WHERE `id`='313';
UPDATE `game_tele` SET `name`='BosqueDelOcaso' WHERE `id`='312';
etc...
How i can do that?
Thanks
Subject
Written By
Posted
How to create SQL script exporting from DB with UPDATES querys?
May 11, 2017 02:23AM
Sorry, you can't reply to this topic. It has been closed.
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.