/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

8 votes207 views1 answer
Mysql limit rows
SQL
2 votes190 views1 answer
Sql alchemy or
SQL
0 vote203 views1 answer
Get first 3 letter of department name in sql
SQL
0 vote189 views1 answer
Sql get month from date
SQL
18 votes184 views3 answers
Mysql query add column with default string value
SQL
2 votes209 views1 answer
Mysql select default if null
SQL
0 vote192 views1 answer
Différence entre deux dates sql oracle
SQL
0 vote199 views1 answer
Postgresql select join by date - Join rows where a timestamp value is equal to midnight of the date
SQL
2 votes207 views1 answer
Where clause for child record apex
SQL
0 vote195 views1 answer
Aktor yang pernah terlibat lebih dari 3 film di sql
SQL