/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 vote166 views1 answer
Openquery insert into linked server
SQL
0 vote172 views1 answer
Procedures sql insert mysql
SQL
11 votes255 views5 answers
Update table from another table mysql
SQL
9 votes165 views3 answers
Oracle undo usage by session
SQL
0 vote166 views1 answer
Postgres where
SQL
0 vote285 views1 answer
How to delete duplicate rows in oracle
SQL
47 votes259 views6 answers
Add column mysql
SQL
0 vote278 views1 answer
Python get backup of sql
SQL
0 vote174 views1 answer
Sql select inside select sub query
SQL
0 vote211 views1 answer
ORA-32794: cannot drop a system-generated sequence
SQL