MySQL Forums
Forum List  »  Newbie

How to create SQL script exporting from DB with UPDATES querys?
Posted by: Locario Ape
Date: May 11, 2017 02:23AM

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

Options: ReplyQuote


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.