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 '18 at 2:00
biiboybiiboy
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 '18 at 2:00
biiboybiiboy
175
Why do you use strings for columns which logically should be integral?
– Amadan
Nov 21 '18 at 2:07
I want change ae_status from 2 to 1.
– biiboy
Nov 21 '18 at 2:10
1
@biiboy is that for all the data in your table?
– Nick
Nov 21 '18 at 2:10
not at all. I want change 2093 data from 15 thousands.
– biiboy
Nov 21 '18 at 2:12
Are the serial numbers consecutive?
– Nick
Nov 21 '18 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 '18 at 2:00
biiboybiiboy
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 '18 at 2:00
biiboybiiboy
175
asked Nov 21 '18 at 2:00
biiboybiiboy
175
asked Nov 21 '18 at 2:00
biiboybiiboy
175
asked Nov 21 '18 at 2:00
biiboybiiboy
175
asked Nov 21 '18 at 2:00
biiboybiiboy
175
175
Why do you use strings for columns which logically should be integral?
– Amadan
Nov 21 '18 at 2:07
I want change ae_status from 2 to 1.
– biiboy
Nov 21 '18 at 2:10
1
@biiboy is that for all the data in your table?
– Nick
Nov 21 '18 at 2:10
not at all. I want change 2093 data from 15 thousands.
– biiboy
Nov 21 '18 at 2:12
Are the serial numbers consecutive?
– Nick
Nov 21 '18 at 2:15
|
show 3 more comments
Why do you use strings for columns which logically should be integral?
– Amadan
Nov 21 '18 at 2:07
I want change ae_status from 2 to 1.
– biiboy
Nov 21 '18 at 2:10
1
@biiboy is that for all the data in your table?
– Nick
Nov 21 '18 at 2:10
not at all. I want change 2093 data from 15 thousands.
– biiboy
Nov 21 '18 at 2:12
Are the serial numbers consecutive?
– Nick
Nov 21 '18 at 2:15
Why do you use strings for columns which logically should be integral?
– Amadan
Nov 21 '18 at 2:07
Why do you use strings for columns which logically should be integral?
– Amadan
Nov 21 '18 at 2:07
I want change ae_status from 2 to 1.
– biiboy
Nov 21 '18 at 2:10
I want change ae_status from 2 to 1.
– biiboy
Nov 21 '18 at 2:10
1
1
@biiboy is that for all the data in your table?
– Nick
Nov 21 '18 at 2:10
@biiboy is that for all the data in your table?
– Nick
Nov 21 '18 at 2:10
not at all. I want change 2093 data from 15 thousands.
– biiboy
Nov 21 '18 at 2:12
not at all. I want change 2093 data from 15 thousands.
– biiboy
Nov 21 '18 at 2:12
Are the serial numbers consecutive?
– Nick
Nov 21 '18 at 2:15
Are the serial numbers consecutive?
– Nick
Nov 21 '18 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 '18 at 2:49
fifonikfifonik
44429
wow.. It Works !!! Thanks. You safe my life
– biiboy
Nov 21 '18 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 '18 at 2:27
comphoniacomphonia
43828
is it more than 1 the serial number ?
– biiboy
Nov 21 '18 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 '18 at 2:49
fifonikfifonik
44429
wow.. It Works !!! Thanks. You safe my life
– biiboy
Nov 21 '18 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 '18 at 2:49
fifonikfifonik
44429
wow.. It Works !!! Thanks. You safe my life
– biiboy
Nov 21 '18 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 '18 at 2:49
fifonikfifonik
44429
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 '18 at 2:49
fifonikfifonik
44429
answered Nov 21 '18 at 2:49
fifonikfifonik
44429
answered Nov 21 '18 at 2:49
fifonikfifonik
44429
answered Nov 21 '18 at 2:49
fifonikfifonik
44429
44429
wow.. It Works !!! Thanks. You safe my life
– biiboy
Nov 21 '18 at 2:54
add a comment |
wow.. It Works !!! Thanks. You safe my life
– biiboy
Nov 21 '18 at 2:54
wow.. It Works !!! Thanks. You safe my life
– biiboy
Nov 21 '18 at 2:54
wow.. It Works !!! Thanks. You safe my life
– biiboy
Nov 21 '18 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 '18 at 2:27
comphoniacomphonia
43828
is it more than 1 the serial number ?
– biiboy
Nov 21 '18 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 '18 at 2:27
comphoniacomphonia
43828
is it more than 1 the serial number ?
– biiboy
Nov 21 '18 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 '18 at 2:27
comphoniacomphonia
43828
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 '18 at 2:27
comphoniacomphonia
43828
answered Nov 21 '18 at 2:27
comphoniacomphonia
43828
answered Nov 21 '18 at 2:27
comphoniacomphonia
43828
answered Nov 21 '18 at 2:27
comphoniacomphonia
43828
43828
is it more than 1 the serial number ?
– biiboy
Nov 21 '18 at 2:38
add a comment |
is it more than 1 the serial number ?
– biiboy
Nov 21 '18 at 2:38
is it more than 1 the serial number ?
– biiboy
Nov 21 '18 at 2:38
is it more than 1 the serial number ?
– biiboy
Nov 21 '18 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.
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 '18 at 2:07
I want change ae_status from 2 to 1.
– biiboy
Nov 21 '18 at 2:10
1
@biiboy is that for all the data in your table?
– Nick
Nov 21 '18 at 2:10
not at all. I want change 2093 data from 15 thousands.
– biiboy
Nov 21 '18 at 2:12
Are the serial numbers consecutive?
– Nick
Nov 21 '18 at 2:15