Styjun

When did F become S in typeography, and why?

What force causes entropy to increase?

How can I define good in a religion that claims no moral authority?

Are my PIs rude or am I just being too sensitive?

Segmentation fault output is suppressed when piping stdin into a function. Why?

Single author papers against my advisor's will?

Program that generates brainfuck code that outputs given text

Road tyres vs "Street" tyres for charity ride on MTB Tandem

What aspect of planet Earth must be changed to prevent the industrial revolution?

What information about me do stores get via my credit card?

Is every episode of "Where are my Pants?" identical?

Did the UK government pay "millions and millions of dollars" to try to snag Julian Assange?

Why can't wing-mounted spoilers be used to steepen approaches?

What is this lever in Argentinian toilets?

He got a vote 80% that of Emmanuel Macron’s

University's motivation for having tenure-track positions

Is it ethical to upload a automatically generated paper to a non peer-reviewed site as part of a larger research?

Take groceries in checked luggage

How to colour the US map with Yellow, Green, Red and Blue to minimize the number of states with the colour of Green

Sort a list of pairs representing an acyclic, partial automorphism

How is simplicity better than precision and clarity in prose?

What do you call a plan that's an alternative plan in case your initial plan fails?

Why does the Event Horizon Telescope (EHT) not include telescopes from Africa, Asia or Australia?

Do working physicists consider Newtonian mechanics to be "falsified"?

Get Storing updated rows and previous rows as well

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty height:90px;width:728px;box-sizing:border-box;

1

Let's suppose I have table as :

column_1 | column_2 | column_3 | column_4


 abc 12 23 34

 abc 01 12 45

I am looking for query something like

insert into table(column_1,column_2,column_3,column_4) values(List of updated rows i.e select (do some logic here of changing value of column_1) from where column_1='abc')

Output should be as :-

column_1 | column_2 | column_3 | column_4


 abc 12 23 34

 abc 01 12 45

 xyz 12 23 34

 xyz 01 12 45

mysql sql database

share|improve this question

edited Mar 22 at 7:06

Dhanraj

asked Mar 22 at 6:48

DhanrajDhanraj

12713

add a comment | 

1

Let's suppose I have table as :

column_1 | column_2 | column_3 | column_4


 abc 12 23 34

 abc 01 12 45

I am looking for query something like

insert into table(column_1,column_2,column_3,column_4) values(List of updated rows i.e select (do some logic here of changing value of column_1) from where column_1='abc')

Output should be as :-

column_1 | column_2 | column_3 | column_4


 abc 12 23 34

 abc 01 12 45

 xyz 12 23 34

 xyz 01 12 45

mysql sql database

share|improve this question

edited Mar 22 at 7:06

Dhanraj

asked Mar 22 at 6:48

DhanrajDhanraj

12713

add a comment | 

Let's suppose I have table as :

column_1 | column_2 | column_3 | column_4


 abc 12 23 34

 abc 01 12 45

I am looking for query something like

insert into table(column_1,column_2,column_3,column_4) values(List of updated rows i.e select (do some logic here of changing value of column_1) from where column_1='abc')

Output should be as :-

column_1 | column_2 | column_3 | column_4


 abc 12 23 34

 abc 01 12 45

 xyz 12 23 34

 xyz 01 12 45

mysql sql database

share|improve this question

edited Mar 22 at 7:06

Dhanraj

asked Mar 22 at 6:48

DhanrajDhanraj

12713

column_1 | column_2 | column_3 | column_4


 abc 12 23 34

 abc 01 12 45

column_1 | column_2 | column_3 | column_4


 abc 12 23 34

 abc 01 12 45

 xyz 12 23 34

 xyz 01 12 45

share|improve this question

edited Mar 22 at 7:06

Dhanraj

asked Mar 22 at 6:48

DhanrajDhanraj

12713

share|improve this question

edited Mar 22 at 7:06

Dhanraj

asked Mar 22 at 6:48

DhanrajDhanraj

12713

asked Mar 22 at 6:48

DhanrajDhanraj

12713

asked Mar 22 at 6:48

DhanrajDhanraj

12713

1 Answer
1

active

oldest

votes

3

You can do it with another select from you insert. it not necessary to use insert into ... (...) values(..). You can use select as well as your value.

insert into table(column1,column2,column3,column4)
select 'xyz' as column1,column2,column3,column4 
from table
where column1 = 'abc'

share|improve this answer

edited Mar 22 at 7:08

Dhanraj

12713

answered Mar 22 at 6:56

Anthony Chan kok kiongAnthony Chan kok kiong

605

add a comment | 

Your Answer

StackExchange.ifUsing("editor", function ()
StackExchange.using("externalEditor", function ()
StackExchange.using("snippets", function ()
StackExchange.snippets.init();
);
);
, "code-snippets");

StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "1"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);

else
createEditor();

);

function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);



);

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);

Sign up using Google

Sign up using Facebook

Sign up using Email and Password

Post as a guest

Name

Email

Required, but never shown

StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55294262%2fget-storing-updated-rows-and-previous-rows-as-well%23new-answer', 'question_page');

);

Post as a guest

Name

Email

Required, but never shown

3

You can do it with another select from you insert. it not necessary to use insert into ... (...) values(..). You can use select as well as your value.

insert into table(column1,column2,column3,column4)
select 'xyz' as column1,column2,column3,column4 
from table
where column1 = 'abc'

share|improve this answer

edited Mar 22 at 7:08

Dhanraj

12713

answered Mar 22 at 6:56

Anthony Chan kok kiongAnthony Chan kok kiong

605

add a comment | 

3

You can do it with another select from you insert. it not necessary to use insert into ... (...) values(..). You can use select as well as your value.

insert into table(column1,column2,column3,column4)
select 'xyz' as column1,column2,column3,column4 
from table
where column1 = 'abc'

share|improve this answer

edited Mar 22 at 7:08

Dhanraj

12713

answered Mar 22 at 6:56

Anthony Chan kok kiongAnthony Chan kok kiong

605

add a comment | 

You can do it with another select from you insert. it not necessary to use insert into ... (...) values(..). You can use select as well as your value.

insert into table(column1,column2,column3,column4)
select 'xyz' as column1,column2,column3,column4 
from table
where column1 = 'abc'

share|improve this answer

edited Mar 22 at 7:08

Dhanraj

12713

answered Mar 22 at 6:56

Anthony Chan kok kiongAnthony Chan kok kiong

605

insert into table(column1,column2,column3,column4)
select 'xyz' as column1,column2,column3,column4 
from table
where column1 = 'abc'

share|improve this answer

edited Mar 22 at 7:08

Dhanraj

12713

answered Mar 22 at 6:56

Anthony Chan kok kiongAnthony Chan kok kiong

605

edited Mar 22 at 7:08

Dhanraj

12713

edited Mar 22 at 7:08

Dhanraj

12713

answered Mar 22 at 6:56

Anthony Chan kok kiongAnthony Chan kok kiong

605

answered Mar 22 at 6:56

Anthony Chan kok kiongAnthony Chan kok kiong

605