/SQL/Define a variable in mysql from select

Define a variable in mysql from select

SELECT salary INTO @variable1 FROM employee_info WHERE emp_id = 12345678 LIMIT 1;
SELECT salary, salary_group INTO @var1, @var2 FROM employee_info WHERE emp_id = 12345678;

Similar codes

1 vote189 views1 answer
Mamp mysql path mac
SQL
0 vote194 views1 answer
Not between mysql
SQL
7 votes212 views2 answers
Where keyword sql
SQL
24 votes212 views6 answers
Sql change table name
SQL
0 vote187 views1 answer
Ms Sql set us timezone
SQL
0 vote192 views1 answer
Sql select duplicates based on two columns
SQL
0 vote200 views1 answer
DELETE DUPLICATE VALUES FROM A TABLE IN SQL SERVER
SQL
0 vote191 views1 answer
Mysql streaming example
SQL
0 vote247 views1 answer
Mysql remove last character
SQL
0 vote213 views1 answer
Convert excel into sqllite db using python
SQL