How to Update with condition from Cursor
I'm using Mysql to Update with condition from a Cursor.
For example I have below query:
declare cur1 cursor for select id from User;
then I want to loop update with condition each id
loop
Update User set name = 'XXXXXXX'
where id = @id --> id from cursor
end loop
How to write this ?
mysql sql database
edited Nov 16 '18 at 11:03
Sami
9,36831244
asked Nov 16 '18 at 10:54
Great SaiyamanGreat Saiyaman
55
add a comment |
I'm using Mysql to Update with condition from a Cursor.
For example I have below query:
declare cur1 cursor for select id from User;
then I want to loop update with condition each id
loop
Update User set name = 'XXXXXXX'
where id = @id --> id from cursor
end loop
How to write this ?
mysql sql database
edited Nov 16 '18 at 11:03
Sami
9,36831244
asked Nov 16 '18 at 10:54
Great SaiyamanGreat Saiyaman
55
add a comment |
I'm using Mysql to Update with condition from a Cursor.
For example I have below query:
declare cur1 cursor for select id from User;
then I want to loop update with condition each id
loop
Update User set name = 'XXXXXXX'
where id = @id --> id from cursor
end loop
How to write this ?
mysql sql database
edited Nov 16 '18 at 11:03
Sami
9,36831244
asked Nov 16 '18 at 10:54
Great SaiyamanGreat Saiyaman
55
I'm using Mysql to Update with condition from a Cursor.
For example I have below query:
declare cur1 cursor for select id from User;
then I want to loop update with condition each id
loop
Update User set name = 'XXXXXXX'
where id = @id --> id from cursor
end loop
How to write this ?
mysql sql database
mysql sql database
edited Nov 16 '18 at 11:03
Sami
9,36831244
asked Nov 16 '18 at 10:54
Great SaiyamanGreat Saiyaman
55
edited Nov 16 '18 at 11:03
Sami
9,36831244
asked Nov 16 '18 at 10:54
Great SaiyamanGreat Saiyaman
55
edited Nov 16 '18 at 11:03
Sami
9,36831244
edited Nov 16 '18 at 11:03
Sami
9,36831244
edited Nov 16 '18 at 11:03
Sami
9,36831244
9,36831244
asked Nov 16 '18 at 10:54
Great SaiyamanGreat Saiyaman
55
asked Nov 16 '18 at 10:54
Great SaiyamanGreat Saiyaman
55
asked Nov 16 '18 at 10:54
Great SaiyamanGreat Saiyaman
55
55
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
I don't even see why you need to/should use a cursor here. A regular update should achieve the same thing:
UPDATE User
SET name = 'XXXXXXX';
Having a WHERE clause in an update is a good thing, but your WHERE clause would just include all records anyway. Assuming the id values were coming from a different table, you could use an update join, something like this:
UPDATE User u
INNER JOIN Other o
ON u.id = o.id
SET name = 'XXXXXXX';
answered Nov 16 '18 at 10:57
Tim BiegeleisenTim Biegeleisen
236k13100160
hi. thx u, but the query is just for sample, i want to update other user table base on value cursor
– Great Saiyaman
Nov 16 '18 at 11:36
You are missing the point of my answer, which is that you probably don't need to even use a cursor here.
– Tim Biegeleisen
Nov 16 '18 at 11:39
im got it, but i have query with many join, if i use UPDATE User u INNER JOIN Other o ON u.id = o.id SET name = 'XXXXXXX'; it take long time event i limit it by 1, but if i add condition UPDATE User u INNER JOIN Other o ON u.id = o.id SET name = 'XXXXXXX' where u.id = 1 ,it running faster ,I use that query just for simplify example
– Great Saiyaman
Nov 16 '18 at 12:38
add a comment |
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
});
}
});
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%2f53336426%2fhow-to-update-with-condition-from-cursor%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
I don't even see why you need to/should use a cursor here. A regular update should achieve the same thing:
UPDATE User
SET name = 'XXXXXXX';
Having a WHERE clause in an update is a good thing, but your WHERE clause would just include all records anyway. Assuming the id values were coming from a different table, you could use an update join, something like this:
UPDATE User u
INNER JOIN Other o
ON u.id = o.id
SET name = 'XXXXXXX';
answered Nov 16 '18 at 10:57
Tim BiegeleisenTim Biegeleisen
236k13100160
hi. thx u, but the query is just for sample, i want to update other user table base on value cursor
– Great Saiyaman
Nov 16 '18 at 11:36
You are missing the point of my answer, which is that you probably don't need to even use a cursor here.
– Tim Biegeleisen
Nov 16 '18 at 11:39
im got it, but i have query with many join, if i use UPDATE User u INNER JOIN Other o ON u.id = o.id SET name = 'XXXXXXX'; it take long time event i limit it by 1, but if i add condition UPDATE User u INNER JOIN Other o ON u.id = o.id SET name = 'XXXXXXX' where u.id = 1 ,it running faster ,I use that query just for simplify example
– Great Saiyaman
Nov 16 '18 at 12:38
add a comment |
I don't even see why you need to/should use a cursor here. A regular update should achieve the same thing:
UPDATE User
SET name = 'XXXXXXX';
Having a WHERE clause in an update is a good thing, but your WHERE clause would just include all records anyway. Assuming the id values were coming from a different table, you could use an update join, something like this:
UPDATE User u
INNER JOIN Other o
ON u.id = o.id
SET name = 'XXXXXXX';
answered Nov 16 '18 at 10:57
Tim BiegeleisenTim Biegeleisen
236k13100160
hi. thx u, but the query is just for sample, i want to update other user table base on value cursor
– Great Saiyaman
Nov 16 '18 at 11:36
You are missing the point of my answer, which is that you probably don't need to even use a cursor here.
– Tim Biegeleisen
Nov 16 '18 at 11:39
im got it, but i have query with many join, if i use UPDATE User u INNER JOIN Other o ON u.id = o.id SET name = 'XXXXXXX'; it take long time event i limit it by 1, but if i add condition UPDATE User u INNER JOIN Other o ON u.id = o.id SET name = 'XXXXXXX' where u.id = 1 ,it running faster ,I use that query just for simplify example
– Great Saiyaman
Nov 16 '18 at 12:38
add a comment |
I don't even see why you need to/should use a cursor here. A regular update should achieve the same thing:
UPDATE User
SET name = 'XXXXXXX';
Having a WHERE clause in an update is a good thing, but your WHERE clause would just include all records anyway. Assuming the id values were coming from a different table, you could use an update join, something like this:
UPDATE User u
INNER JOIN Other o
ON u.id = o.id
SET name = 'XXXXXXX';
answered Nov 16 '18 at 10:57
Tim BiegeleisenTim Biegeleisen
236k13100160
I don't even see why you need to/should use a cursor here. A regular update should achieve the same thing:
UPDATE User
SET name = 'XXXXXXX';
Having a WHERE clause in an update is a good thing, but your WHERE clause would just include all records anyway. Assuming the id values were coming from a different table, you could use an update join, something like this:
UPDATE User u
INNER JOIN Other o
ON u.id = o.id
SET name = 'XXXXXXX';
answered Nov 16 '18 at 10:57
Tim BiegeleisenTim Biegeleisen
236k13100160
answered Nov 16 '18 at 10:57
Tim BiegeleisenTim Biegeleisen
236k13100160
answered Nov 16 '18 at 10:57
Tim BiegeleisenTim Biegeleisen
236k13100160
answered Nov 16 '18 at 10:57
Tim BiegeleisenTim Biegeleisen
236k13100160
236k13100160
hi. thx u, but the query is just for sample, i want to update other user table base on value cursor
– Great Saiyaman
Nov 16 '18 at 11:36
You are missing the point of my answer, which is that you probably don't need to even use a cursor here.
– Tim Biegeleisen
Nov 16 '18 at 11:39
im got it, but i have query with many join, if i use UPDATE User u INNER JOIN Other o ON u.id = o.id SET name = 'XXXXXXX'; it take long time event i limit it by 1, but if i add condition UPDATE User u INNER JOIN Other o ON u.id = o.id SET name = 'XXXXXXX' where u.id = 1 ,it running faster ,I use that query just for simplify example
– Great Saiyaman
Nov 16 '18 at 12:38
add a comment |
hi. thx u, but the query is just for sample, i want to update other user table base on value cursor
– Great Saiyaman
Nov 16 '18 at 11:36
You are missing the point of my answer, which is that you probably don't need to even use a cursor here.
– Tim Biegeleisen
Nov 16 '18 at 11:39
im got it, but i have query with many join, if i use UPDATE User u INNER JOIN Other o ON u.id = o.id SET name = 'XXXXXXX'; it take long time event i limit it by 1, but if i add condition UPDATE User u INNER JOIN Other o ON u.id = o.id SET name = 'XXXXXXX' where u.id = 1 ,it running faster ,I use that query just for simplify example
– Great Saiyaman
Nov 16 '18 at 12:38
hi. thx u, but the query is just for sample, i want to update other user table base on value cursor
– Great Saiyaman
Nov 16 '18 at 11:36
hi. thx u, but the query is just for sample, i want to update other user table base on value cursor
– Great Saiyaman
Nov 16 '18 at 11:36
You are missing the point of my answer, which is that you probably don't need to even use a cursor here.
– Tim Biegeleisen
Nov 16 '18 at 11:39
You are missing the point of my answer, which is that you probably don't need to even use a cursor here.
– Tim Biegeleisen
Nov 16 '18 at 11:39
im got it, but i have query with many join, if i use UPDATE User u INNER JOIN Other o ON u.id = o.id SET name = 'XXXXXXX'; it take long time event i limit it by 1, but if i add condition UPDATE User u INNER JOIN Other o ON u.id = o.id SET name = 'XXXXXXX' where u.id = 1 ,it running faster ,I use that query just for simplify example
– Great Saiyaman
Nov 16 '18 at 12:38
im got it, but i have query with many join, if i use UPDATE User u INNER JOIN Other o ON u.id = o.id SET name = 'XXXXXXX'; it take long time event i limit it by 1, but if i add condition UPDATE User u INNER JOIN Other o ON u.id = o.id SET name = 'XXXXXXX' where u.id = 1 ,it running faster ,I use that query just for simplify example
– Great Saiyaman
Nov 16 '18 at 12:38
add a comment |
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.
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%2f53336426%2fhow-to-update-with-condition-from-cursor%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
