/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

0 vote261 views1 answer
Min salary in sql
SQL
0 vote263 views1 answer
Drop all tables in azure sql database
SQL
1 vote269 views1 answer
Mysql show long running queries
SQL
5 votes306 views2 answers
Add days in oracle sql
SQL
0 vote286 views1 answer
Sql alter column name sql server
SQL
0 vote267 views1 answer
Where case insensitive like mysql
SQL
0 vote266 views1 answer
In mysql workbench contnent not feching
SQL
0 vote311 views1 answer
How to inner join 4 tables in sql
SQL
0 vote277 views1 answer
Returning with sqlalchemy
SQL
9 votes290 views4 answers
Mysql set id auto increment
SQL