Update Multiple ROW by Primary Key
0
I have more than 2000 data but I entered the status number incorrectly. I should enter 1 (deployed) but I use 2 (In Inventory).
How do I change the status from 2 to 1 with thousands of data?
I'm trying with this code
UPDATE asset_existing
SET
ae_status = '1'
WHERE ae_serial_number = '1'
UPDATE asset_existing
SET
ae_status = '1'
WHERE ae_serial_number = '2';
UPDATE asset_existing
SET
ae_status = '1'
WHERE ae_serial_number = '3';
UPDATE asset_existing
SET
ae_status = '1'
WHERE ae_serial_number = '3';
UPDATE asset_existing
SET
ae_status = '1'
WHERE ae_serial_number = '4';
mysql sql xampp sql-update
asked Nov 21 at 2:00
biiboy
175
|
show 3 more comments
0
I have more than 2000 data but I entered the status number incorrectly. I should enter 1 (deployed) but I use 2 (In Inventory).
How do I change the status from 2 to 1 with thousands of data?
I'm trying with this code
UPDATE asset_existing
SET
ae_status = '1'
WHERE ae_serial_number = '1'
UPDATE asset_existing
SET
ae_status = '1'
WHERE ae_serial_number = '2';
UPDATE asset_existing
SET
ae_status = '1'
WHERE ae_serial_number = '3';
UPDATE asset_existing
SET
ae_status = '1'
WHERE ae_serial_number = '3';
UPDATE asset_existing
SET
ae_status = '1'
WHERE ae_serial_number = '4';
mysql sql xampp sql-update
asked Nov 21 at 2:00
biiboy
175
Why do you use strings for columns which logically should be integral?
– Amadan
Nov 21 at 2:07
I want change ae_status from 2 to 1.
– biiboy
Nov 21 at 2:10
1
@biiboy is that for all the data in your table?
– Nick
Nov 21 at 2:10
not at all. I want change 2093 data from 15 thousands.
– biiboy
Nov 21 at 2:12
Are the serial numbers consecutive?
– Nick
Nov 21 at 2:15
|
show 3 more comments
0
0
0
I have more than 2000 data but I entered the status number incorrectly. I should enter 1 (deployed) but I use 2 (In Inventory).
How do I change the status from 2 to 1 with thousands of data?
I'm trying with this code
UPDATE asset_existing
SET
ae_status = '1'
WHERE ae_serial_number = '1'
UPDATE asset_existing
SET
ae_status = '1'
WHERE ae_serial_number = '2';
UPDATE asset_existing
SET
ae_status = '1'
WHERE ae_serial_number = '3';
UPDATE asset_existing
SET
ae_status = '1'
WHERE ae_serial_number = '3';
UPDATE asset_existing
SET
ae_status = '1'
WHERE ae_serial_number = '4';
mysql sql xampp sql-update
asked Nov 21 at 2:00
biiboy
175
I have more than 2000 data but I entered the status number incorrectly. I should enter 1 (deployed) but I use 2 (In Inventory).
How do I change the status from 2 to 1 with thousands of data?
I'm trying with this code
UPDATE asset_existing
SET
ae_status = '1'
WHERE ae_serial_number = '1'
UPDATE asset_existing
SET
ae_status = '1'
WHERE ae_serial_number = '2';
UPDATE asset_existing
SET
ae_status = '1'
WHERE ae_serial_number = '3';
UPDATE asset_existing
SET
ae_status = '1'
WHERE ae_serial_number = '3';
UPDATE asset_existing
SET
ae_status = '1'
WHERE ae_serial_number = '4';
mysql sql xampp sql-update
mysql sql xampp sql-update
asked Nov 21 at 2:00
biiboy
175
asked Nov 21 at 2:00
biiboy
175
asked Nov 21 at 2:00
biiboy
175
asked Nov 21 at 2:00
biiboy
175
asked Nov 21 at 2:00
biiboy
175
175
Why do you use strings for columns which logically should be integral?
– Amadan
Nov 21 at 2:07
I want change ae_status from 2 to 1.
– biiboy
Nov 21 at 2:10
1
@biiboy is that for all the data in your table?
– Nick
Nov 21 at 2:10
not at all. I want change 2093 data from 15 thousands.
– biiboy
Nov 21 at 2:12
Are the serial numbers consecutive?
– Nick
Nov 21 at 2:15
|
show 3 more comments
Why do you use strings for columns which logically should be integral?
– Amadan
Nov 21 at 2:07
I want change ae_status from 2 to 1.
– biiboy
Nov 21 at 2:10
1
@biiboy is that for all the data in your table?
– Nick
Nov 21 at 2:10
not at all. I want change 2093 data from 15 thousands.
– biiboy
Nov 21 at 2:12
Are the serial numbers consecutive?
– Nick
Nov 21 at 2:15
Why do you use strings for columns which logically should be integral?
– Amadan
Nov 21 at 2:07
Why do you use strings for columns which logically should be integral?
– Amadan
Nov 21 at 2:07
I want change ae_status from 2 to 1.
– biiboy
Nov 21 at 2:10
I want change ae_status from 2 to 1.
– biiboy
Nov 21 at 2:10
1
1
@biiboy is that for all the data in your table?
– Nick
Nov 21 at 2:10
@biiboy is that for all the data in your table?
– Nick
Nov 21 at 2:10
not at all. I want change 2093 data from 15 thousands.
– biiboy
Nov 21 at 2:12
not at all. I want change 2093 data from 15 thousands.
– biiboy
Nov 21 at 2:12
Are the serial numbers consecutive?
– Nick
Nov 21 at 2:15
Are the serial numbers consecutive?
– Nick
Nov 21 at 2:15
|
show 3 more comments
2 Answers
2
active
oldest
votes
1
Not sure why you cannot simply execute:
UPDATE
asset_existing
SET
ae_status = '1'
WHERE
ae_serial_number IN ('1', '2', '3', ...)
AND ae_status = '2'
;
?
I've added ae_status = '2' in where clause to be on a safe side.
answered Nov 21 at 2:49
fifonik
38518
wow.. It Works !!! Thanks. You safe my life
– biiboy
Nov 21 at 2:54
add a comment |
0
If you have a lot of records that have ae_status = 2 and you want to change them to 1
UPDATE asset_existing
SET
ae_status = '1'
WHERE ae_status = '2';
answered Nov 21 at 2:27
comphonia
42828
is it more than 1 the serial number ?
– biiboy
Nov 21 at 2:38
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
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53404313%2fupdate-multiple-row-by-primary-key%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
2 Answers
2
active
oldest
votes
2 Answers
2
active
oldest
votes
active
oldest
votes
active
oldest
votes
1
Not sure why you cannot simply execute:
UPDATE
asset_existing
SET
ae_status = '1'
WHERE
ae_serial_number IN ('1', '2', '3', ...)
AND ae_status = '2'
;
?
I've added ae_status = '2' in where clause to be on a safe side.
answered Nov 21 at 2:49
fifonik
38518
wow.. It Works !!! Thanks. You safe my life
– biiboy
Nov 21 at 2:54
add a comment |
1
Not sure why you cannot simply execute:
UPDATE
asset_existing
SET
ae_status = '1'
WHERE
ae_serial_number IN ('1', '2', '3', ...)
AND ae_status = '2'
;
?
I've added ae_status = '2' in where clause to be on a safe side.
answered Nov 21 at 2:49
fifonik
38518
wow.. It Works !!! Thanks. You safe my life
– biiboy
Nov 21 at 2:54
add a comment |
1
1
1
Not sure why you cannot simply execute:
UPDATE
asset_existing
SET
ae_status = '1'
WHERE
ae_serial_number IN ('1', '2', '3', ...)
AND ae_status = '2'
;
?
I've added ae_status = '2' in where clause to be on a safe side.
answered Nov 21 at 2:49
fifonik
38518
Not sure why you cannot simply execute:
UPDATE
asset_existing
SET
ae_status = '1'
WHERE
ae_serial_number IN ('1', '2', '3', ...)
AND ae_status = '2'
;
?
I've added ae_status = '2' in where clause to be on a safe side.
answered Nov 21 at 2:49
fifonik
38518
answered Nov 21 at 2:49
fifonik
38518
answered Nov 21 at 2:49
fifonik
38518
answered Nov 21 at 2:49
fifonik
38518
38518
wow.. It Works !!! Thanks. You safe my life
– biiboy
Nov 21 at 2:54
add a comment |
wow.. It Works !!! Thanks. You safe my life
– biiboy
Nov 21 at 2:54
wow.. It Works !!! Thanks. You safe my life
– biiboy
Nov 21 at 2:54
wow.. It Works !!! Thanks. You safe my life
– biiboy
Nov 21 at 2:54
add a comment |
0
If you have a lot of records that have ae_status = 2 and you want to change them to 1
UPDATE asset_existing
SET
ae_status = '1'
WHERE ae_status = '2';
answered Nov 21 at 2:27
comphonia
42828
is it more than 1 the serial number ?
– biiboy
Nov 21 at 2:38
add a comment |
0
If you have a lot of records that have ae_status = 2 and you want to change them to 1
UPDATE asset_existing
SET
ae_status = '1'
WHERE ae_status = '2';
answered Nov 21 at 2:27
comphonia
42828
is it more than 1 the serial number ?
– biiboy
Nov 21 at 2:38
add a comment |
0
0
0
If you have a lot of records that have ae_status = 2 and you want to change them to 1
UPDATE asset_existing
SET
ae_status = '1'
WHERE ae_status = '2';
answered Nov 21 at 2:27
comphonia
42828
If you have a lot of records that have ae_status = 2 and you want to change them to 1
UPDATE asset_existing
SET
ae_status = '1'
WHERE ae_status = '2';
answered Nov 21 at 2:27
comphonia
42828
answered Nov 21 at 2:27
comphonia
42828
answered Nov 21 at 2:27
comphonia
42828
answered Nov 21 at 2:27
comphonia
42828
42828
is it more than 1 the serial number ?
– biiboy
Nov 21 at 2:38
add a comment |
is it more than 1 the serial number ?
– biiboy
Nov 21 at 2:38
is it more than 1 the serial number ?
– biiboy
Nov 21 at 2:38
is it more than 1 the serial number ?
– biiboy
Nov 21 at 2:38
add a comment |
draft saved
draft discarded
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Some of your past answers have not been well-received, and you're in danger of being blocked from answering.
Please pay close attention to the following guidance:
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
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
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53404313%2fupdate-multiple-row-by-primary-key%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
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
Required, but never shown
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
Required, but never shown
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
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Why do you use strings for columns which logically should be integral?
– Amadan
Nov 21 at 2:07
I want change ae_status from 2 to 1.
– biiboy
Nov 21 at 2:10
1
@biiboy is that for all the data in your table?
– Nick
Nov 21 at 2:10
not at all. I want change 2093 data from 15 thousands.
– biiboy
Nov 21 at 2:12
Are the serial numbers consecutive?
– Nick
Nov 21 at 2:15