Save Variable in SQL

Question

Is there a way for me to save the values my SELECT statement returns in to a variable in SQL?

This is what i want to do, first i want to SELECT all the columns i wanna check so in this case ItemNames of the items with ItemCategory US.

SELECT `ItemName` where `ItemCategory´= 'US'

Then I want to save the ItemName from the statement above into a variable in SQL to use it later on in the same query. Like this:

SELECT `DatabaseID` where `Project` NOT LIKE `myVariable`

Thanks in regards

see this: stackoverflow.com/questions/10070406/…

Pathik Vejani
– Pathik Vejani

2016-02-24 13:30:58 +00:00
Commented Feb 24, 2016 at 13:30 — Pathik Vejani
– Pathik Vejani, Commented Feb 24, 2016 at 13:30
Why don't just mix them up together?

sagi
– sagi

2016-02-24 13:31:37 +00:00
Commented Feb 24, 2016 at 13:31 — sagi
– sagi, Commented Feb 24, 2016 at 13:31

Rahul Tripathi · Accepted Answer · 2016-02-24 13:32:03Z

7

You can try like this:

SELECT `ItemName` into @myVar FROM mytable where `ItemCategory´= 'US';

or

SELECT @myVar := `ItemName` FROM mytable where `ItemCategory´= 'US'

However you can combine your query to one like this:

SELECT `DatabaseID` from mytable 
where `Project` NOT IN (SELECT `ItemName` where `ItemCategory´= 'US')

answered Feb 24, 2016 at 13:32

Rahul Tripathi

173k33 gold badges292 silver badges341 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Rahul Tripathi · Accepted Answer · 2016-02-24 13:38:32Z

1

declare @var varchar(50);
SELECT @var = 'US' 
SELECT * FROM Country where Name NOT LIKE @var

edited Feb 24, 2016 at 13:38

Rahul Tripathi

173k33 gold badges292 silver badges341 bronze badges

answered Feb 24, 2016 at 13:38

Abdul Waheed Khan

515 bronze badges

Comments

Danny Leandro · Accepted Answer · 2016-02-24 14:12:21Z

0

What you can do is store the results in a variable table or temporary table, something like this:

SQL Server:

create table #Temp
(
    ItemName As Varchar(50)
    --col2 AS Int, 
    --col3 As Varchar(20)
    --...
)

MySQL

CREATE TEMPORARY TABLE IF NOT EXISTS table1 (ItemName VARCHAR(50)) -- You can add more columns: (ItemName VARCHAR(50), col2 int NOT NULL DEFAULT 0, col3 VARCHAR(20),...)

Then put the results in the table #Temp or table1

SQL Server

Insert Into #Temp SELECT ItemName FROM mytable where ItemCategory= 'US';

MySQL

Insert Into table1 SELECT ItemName FROM mytable where ItemCategory= 'US';

And then you can play with both tables and make different operations (e.g. make joins)

edited Feb 24, 2016 at 14:12

answered Feb 24, 2016 at 13:47

Danny Leandro

1329 bronze badges

Collectives™ on Stack Overflow

Save Variable in SQL

3 Answers 3

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related