MySql create variable from sql select

up vote
0
down vote

favorite

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

asked Nov 19 at 12:22

gstackoverflow

9,39144159339

add a comment |

up vote
0
down vote

favorite

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

asked Nov 19 at 12:22

gstackoverflow

9,39144159339

add a comment |

up vote
0
down vote

favorite

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

asked Nov 19 at 12:22

gstackoverflow

9,39144159339

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 at 12:22

gstackoverflow

9,39144159339

asked Nov 19 at 12:22

gstackoverflow

9,39144159339

asked Nov 19 at 12:22

gstackoverflow

9,39144159339

asked Nov 19 at 12:22

gstackoverflow

9,39144159339

asked Nov 19 at 12:22

gstackoverflow

9,39144159339

add a comment |

2 Answers
2

active

oldest

votes

up vote
2
down vote

accepted

Are you trying to do this?

SELECT @MY_ID := ID

FROM TMS.MY_TABLE

WHERE MY_TABLE.UNIQ_COLUMN = 2134;

answered Nov 19 at 12:23

Gordon Linoff

751k34286393

It works fine! Many thanks
– gstackoverflow
Nov 19 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 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 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 at 12:42

@Raymond Nijland good point)
– gstackoverflow
Nov 19 at 12:47

add a comment |

up vote
1
down vote

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 at 12:31

Raymond Nijland

7,67121327

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',
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');
});

Post as a guest

Name

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

Name

Required, but never shown

2 Answers
2

active

oldest

votes

2 Answers
2

active

oldest

votes

up vote
2
down vote

accepted

Are you trying to do this?

SELECT @MY_ID := ID

FROM TMS.MY_TABLE

WHERE MY_TABLE.UNIQ_COLUMN = 2134;

answered Nov 19 at 12:23

Gordon Linoff

751k34286393

It works fine! Many thanks
– gstackoverflow
Nov 19 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 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 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 at 12:42

@Raymond Nijland good point)
– gstackoverflow
Nov 19 at 12:47

add a comment |

up vote
2
down vote

accepted

Are you trying to do this?

SELECT @MY_ID := ID

FROM TMS.MY_TABLE

WHERE MY_TABLE.UNIQ_COLUMN = 2134;

answered Nov 19 at 12:23

Gordon Linoff

751k34286393

It works fine! Many thanks
– gstackoverflow
Nov 19 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 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 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 at 12:42

@Raymond Nijland good point)
– gstackoverflow
Nov 19 at 12:47

add a comment |

up vote
2
down vote

accepted

Are you trying to do this?

SELECT @MY_ID := ID

FROM TMS.MY_TABLE

WHERE MY_TABLE.UNIQ_COLUMN = 2134;

answered Nov 19 at 12:23

Gordon Linoff

751k34286393

Are you trying to do this?

SELECT @MY_ID := ID

FROM TMS.MY_TABLE

WHERE MY_TABLE.UNIQ_COLUMN = 2134;

answered Nov 19 at 12:23

Gordon Linoff

751k34286393

answered Nov 19 at 12:23

Gordon Linoff

751k34286393

answered Nov 19 at 12:23

Gordon Linoff

751k34286393

answered Nov 19 at 12:23

Gordon Linoff

751k34286393

It works fine! Many thanks
– gstackoverflow
Nov 19 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 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 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 at 12:42

@Raymond Nijland good point)
– gstackoverflow
Nov 19 at 12:47

add a comment |

It works fine! Many thanks
– gstackoverflow
Nov 19 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 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 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 at 12:42

@Raymond Nijland good point)
– gstackoverflow
Nov 19 at 12:47

It works fine! Many thanks
– gstackoverflow
Nov 19 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 at 12:32

@Raymond Nijland, thanks for reminder but as you can see I provided that I use column with name UNIQ_COLUMN
– gstackoverflow
Nov 19 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 at 12:42

@Raymond Nijland good point)
– gstackoverflow
Nov 19 at 12:47

add a comment |

up vote
1
down vote

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 at 12:31

Raymond Nijland

7,67121327

add a comment |

up vote
1
down vote

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 at 12:31

Raymond Nijland

7,67121327

add a comment |

up vote
1
down vote

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 at 12:31

Raymond Nijland

7,67121327

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 at 12:31

Raymond Nijland

7,67121327

answered Nov 19 at 12:31

Raymond Nijland

7,67121327

answered Nov 19 at 12:31

Raymond Nijland

7,67121327

answered Nov 19 at 12:31

Raymond Nijland

7,67121327

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');
});

Post as a guest

Name

Required, but never shown

Post as a guest

Name

Required, but never shown

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

Name

Required, but never shown

Name

Required, but never shown

This page is only for reference, If you need detailed information, please check here

搜尋此網誌

Argthtjtr