Mixing
MySql create variable from sql select
Is there way to create variable from select ?
set @MY_ID = 'SELECT ID FROM TMS.MY_TABLE WHERE MY_TABLE.UNIQ_COLUMN= 2134';
Code above works but it just saves string:
SELECT @MY_ID; returns
SELECT ID FROM TMS.MY_TABLE WHERE MY_TABLE.UNIQ_COLUMN= 2134'
I have to know this id to use it as foreign key to insert into another tables
mysql sql variables
asked Nov 19 '18 at 12:22
gstackoverflow
9,66844165350
add a comment |
Is there way to create variable from select ?
set @MY_ID = 'SELECT ID FROM TMS.MY_TABLE WHERE MY_TABLE.UNIQ_COLUMN= 2134';
Code above works but it just saves string:
SELECT @MY_ID; returns
SELECT ID FROM TMS.MY_TABLE WHERE MY_TABLE.UNIQ_COLUMN= 2134'
I have to know this id to use it as foreign key to insert into another tables
mysql sql variables
asked Nov 19 '18 at 12:22
gstackoverflow
9,66844165350
add a comment |
Is there way to create variable from select ?
set @MY_ID = 'SELECT ID FROM TMS.MY_TABLE WHERE MY_TABLE.UNIQ_COLUMN= 2134';
Code above works but it just saves string:
SELECT @MY_ID; returns
SELECT ID FROM TMS.MY_TABLE WHERE MY_TABLE.UNIQ_COLUMN= 2134'
I have to know this id to use it as foreign key to insert into another tables
mysql sql variables
asked Nov 19 '18 at 12:22
gstackoverflow
9,66844165350
Is there way to create variable from select ?
set @MY_ID = 'SELECT ID FROM TMS.MY_TABLE WHERE MY_TABLE.UNIQ_COLUMN= 2134';
Code above works but it just saves string:
SELECT @MY_ID; returns
SELECT ID FROM TMS.MY_TABLE WHERE MY_TABLE.UNIQ_COLUMN= 2134'
I have to know this id to use it as foreign key to insert into another tables
mysql sql variables
mysql sql variables
asked Nov 19 '18 at 12:22
gstackoverflow
9,66844165350
asked Nov 19 '18 at 12:22
gstackoverflow
9,66844165350
asked Nov 19 '18 at 12:22
gstackoverflow
9,66844165350
asked Nov 19 '18 at 12:22
gstackoverflow
9,66844165350
asked Nov 19 '18 at 12:22
gstackoverflow
9,66844165350
9,66844165350
add a comment |
add a comment |
2 Answers
2
active
oldest
votes
Are you trying to do this?
SELECT @MY_ID := ID
FROM TMS.MY_TABLE
WHERE MY_TABLE.UNIQ_COLUMN = 2134;
answered Nov 19 '18 at 12:23
Gordon Linoff
758k35291399
It works fine! Many thanks
– gstackoverflow
Nov 19 '18 at 12:26
@gstackoverflow Be sure the result can only have one record. So most likely you need to addORDER BY column LIMIT 1ifMY_TABLE.UNIQ_COLUMNnot has a unique or primary key
– Raymond Nijland
Nov 19 '18 at 12:32
1
@Raymond Nijland, thanks for reminder but as you can see I provided that I use column with name UNIQ_COLUMN
– gstackoverflow
Nov 19 '18 at 12:38
@gstackoverflow Ok how should i know maybeUNIQmeant somethingunix qualityorunix quantityor something else like that
– Raymond Nijland
Nov 19 '18 at 12:42
@Raymond Nijland good point)
– gstackoverflow
Nov 19 '18 at 12:47
add a comment |
The other variation would be
SELECT
ID
FROM
TMS.MY_TABLE
INTO @MY_ID
WHERE
MY_TABLE.UNIQ_COLUMN = 2134
Be sure the result can only have one record. So most likely you need to add ORDER BY column LIMIT 1 if MY_TABLE.UNIQ_COLUMN not has a unique or primary key
answered Nov 19 '18 at 12:31
Raymond Nijland
7,90921328
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
});
}
});
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%2f53374558%2fmysql-create-variable-from-sql-select%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
Are you trying to do this?
SELECT @MY_ID := ID
FROM TMS.MY_TABLE
WHERE MY_TABLE.UNIQ_COLUMN = 2134;
answered Nov 19 '18 at 12:23
Gordon Linoff
758k35291399
It works fine! Many thanks
– gstackoverflow
Nov 19 '18 at 12:26
@gstackoverflow Be sure the result can only have one record. So most likely you need to addORDER BY column LIMIT 1ifMY_TABLE.UNIQ_COLUMNnot has a unique or primary key
– Raymond Nijland
Nov 19 '18 at 12:32
1
@Raymond Nijland, thanks for reminder but as you can see I provided that I use column with name UNIQ_COLUMN
– gstackoverflow
Nov 19 '18 at 12:38
@gstackoverflow Ok how should i know maybeUNIQmeant somethingunix qualityorunix quantityor something else like that
– Raymond Nijland
Nov 19 '18 at 12:42
@Raymond Nijland good point)
– gstackoverflow
Nov 19 '18 at 12:47
add a comment |
Are you trying to do this?
SELECT @MY_ID := ID
FROM TMS.MY_TABLE
WHERE MY_TABLE.UNIQ_COLUMN = 2134;
answered Nov 19 '18 at 12:23
Gordon Linoff
758k35291399
It works fine! Many thanks
– gstackoverflow
Nov 19 '18 at 12:26
@gstackoverflow Be sure the result can only have one record. So most likely you need to addORDER BY column LIMIT 1ifMY_TABLE.UNIQ_COLUMNnot has a unique or primary key
– Raymond Nijland
Nov 19 '18 at 12:32
1
@Raymond Nijland, thanks for reminder but as you can see I provided that I use column with name UNIQ_COLUMN
– gstackoverflow
Nov 19 '18 at 12:38
@gstackoverflow Ok how should i know maybeUNIQmeant somethingunix qualityorunix quantityor something else like that
– Raymond Nijland
Nov 19 '18 at 12:42
@Raymond Nijland good point)
– gstackoverflow
Nov 19 '18 at 12:47
add a comment |
Are you trying to do this?
SELECT @MY_ID := ID
FROM TMS.MY_TABLE
WHERE MY_TABLE.UNIQ_COLUMN = 2134;
answered Nov 19 '18 at 12:23
Gordon Linoff
758k35291399
Are you trying to do this?
SELECT @MY_ID := ID
FROM TMS.MY_TABLE
WHERE MY_TABLE.UNIQ_COLUMN = 2134;
answered Nov 19 '18 at 12:23
Gordon Linoff
758k35291399
answered Nov 19 '18 at 12:23
Gordon Linoff
758k35291399
answered Nov 19 '18 at 12:23
Gordon Linoff
758k35291399
answered Nov 19 '18 at 12:23
Gordon Linoff
758k35291399
758k35291399
It works fine! Many thanks
– gstackoverflow
Nov 19 '18 at 12:26
@gstackoverflow Be sure the result can only have one record. So most likely you need to addORDER BY column LIMIT 1ifMY_TABLE.UNIQ_COLUMNnot has a unique or primary key
– Raymond Nijland
Nov 19 '18 at 12:32
1
@Raymond Nijland, thanks for reminder but as you can see I provided that I use column with name UNIQ_COLUMN
– gstackoverflow
Nov 19 '18 at 12:38
@gstackoverflow Ok how should i know maybeUNIQmeant somethingunix qualityorunix quantityor something else like that
– Raymond Nijland
Nov 19 '18 at 12:42
@Raymond Nijland good point)
– gstackoverflow
Nov 19 '18 at 12:47
add a comment |
It works fine! Many thanks
– gstackoverflow
Nov 19 '18 at 12:26
@gstackoverflow Be sure the result can only have one record. So most likely you need to addORDER BY column LIMIT 1ifMY_TABLE.UNIQ_COLUMNnot has a unique or primary key
– Raymond Nijland
Nov 19 '18 at 12:32
1
@Raymond Nijland, thanks for reminder but as you can see I provided that I use column with name UNIQ_COLUMN
– gstackoverflow
Nov 19 '18 at 12:38
@gstackoverflow Ok how should i know maybeUNIQmeant somethingunix qualityorunix quantityor something else like that
– Raymond Nijland
Nov 19 '18 at 12:42
@Raymond Nijland good point)
– gstackoverflow
Nov 19 '18 at 12:47
It works fine! Many thanks
– gstackoverflow
Nov 19 '18 at 12:26
It works fine! Many thanks
– gstackoverflow
Nov 19 '18 at 12:26
@gstackoverflow Be sure the result can only have one record. So most likely you need to add
ORDER BY column LIMIT 1 if MY_TABLE.UNIQ_COLUMN not has a unique or primary key– Raymond Nijland
Nov 19 '18 at 12:32
@gstackoverflow Be sure the result can only have one record. So most likely you need to add
ORDER BY column LIMIT 1 if MY_TABLE.UNIQ_COLUMN not has a unique or primary key– Raymond Nijland
Nov 19 '18 at 12:32
1
1
@Raymond Nijland, thanks for reminder but as you can see I provided that I use column with name UNIQ_COLUMN
– gstackoverflow
Nov 19 '18 at 12:38
@Raymond Nijland, thanks for reminder but as you can see I provided that I use column with name UNIQ_COLUMN
– gstackoverflow
Nov 19 '18 at 12:38
@gstackoverflow Ok how should i know maybe
UNIQ meant something unix quality or unix quantity or something else like that– Raymond Nijland
Nov 19 '18 at 12:42
@gstackoverflow Ok how should i know maybe
UNIQ meant something unix quality or unix quantity or something else like that– Raymond Nijland
Nov 19 '18 at 12:42
@Raymond Nijland good point)
– gstackoverflow
Nov 19 '18 at 12:47
@Raymond Nijland good point)
– gstackoverflow
Nov 19 '18 at 12:47
add a comment |
The other variation would be
SELECT
ID
FROM
TMS.MY_TABLE
INTO @MY_ID
WHERE
MY_TABLE.UNIQ_COLUMN = 2134
Be sure the result can only have one record. So most likely you need to add ORDER BY column LIMIT 1 if MY_TABLE.UNIQ_COLUMN not has a unique or primary key
answered Nov 19 '18 at 12:31
Raymond Nijland
7,90921328
add a comment |
The other variation would be
SELECT
ID
FROM
TMS.MY_TABLE
INTO @MY_ID
WHERE
MY_TABLE.UNIQ_COLUMN = 2134
Be sure the result can only have one record. So most likely you need to add ORDER BY column LIMIT 1 if MY_TABLE.UNIQ_COLUMN not has a unique or primary key
answered Nov 19 '18 at 12:31
Raymond Nijland
7,90921328
add a comment |
The other variation would be
SELECT
ID
FROM
TMS.MY_TABLE
INTO @MY_ID
WHERE
MY_TABLE.UNIQ_COLUMN = 2134
Be sure the result can only have one record. So most likely you need to add ORDER BY column LIMIT 1 if MY_TABLE.UNIQ_COLUMN not has a unique or primary key
answered Nov 19 '18 at 12:31
Raymond Nijland
7,90921328
The other variation would be
SELECT
ID
FROM
TMS.MY_TABLE
INTO @MY_ID
WHERE
MY_TABLE.UNIQ_COLUMN = 2134
Be sure the result can only have one record. So most likely you need to add ORDER BY column LIMIT 1 if MY_TABLE.UNIQ_COLUMN not has a unique or primary key
answered Nov 19 '18 at 12:31
Raymond Nijland
7,90921328
answered Nov 19 '18 at 12:31
Raymond Nijland
7,90921328
answered Nov 19 '18 at 12:31
Raymond Nijland
7,90921328
answered Nov 19 '18 at 12:31
Raymond Nijland
7,90921328
7,90921328
add a comment |
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.
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.
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%2f53374558%2fmysql-create-variable-from-sql-select%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
