Update Multiple ROW by Primary Key
up vote
0
down vote
favorite
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
|
show 3 more comments
up vote
0
down vote
favorite
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
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
up vote
0
down vote
favorite
up vote
0
down vote
favorite
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
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
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
up vote
1
down vote
accepted
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.
wow.. It Works !!! Thanks. You safe my life
– biiboy
Nov 21 at 2:54
add a comment |
up vote
0
down vote
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';
is it more than 1 the serial number ?
– biiboy
Nov 21 at 2:38
add a comment |
2 Answers
2
active
oldest
votes
2 Answers
2
active
oldest
votes
active
oldest
votes
active
oldest
votes
up vote
1
down vote
accepted
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.
wow.. It Works !!! Thanks. You safe my life
– biiboy
Nov 21 at 2:54
add a comment |
up vote
1
down vote
accepted
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.
wow.. It Works !!! Thanks. You safe my life
– biiboy
Nov 21 at 2:54
add a comment |
up vote
1
down vote
accepted
up vote
1
down vote
accepted
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.
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
974
974
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 |
up vote
0
down vote
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';
is it more than 1 the serial number ?
– biiboy
Nov 21 at 2:38
add a comment |
up vote
0
down vote
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';
is it more than 1 the serial number ?
– biiboy
Nov 21 at 2:38
add a comment |
up vote
0
down vote
up vote
0
down vote
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';
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
32917
32917
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 |
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