/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

2 votes197 views1 answer
Oracle percentage
SQL
0 vote204 views1 answer
How to to get time in sql
SQL
0 vote186 views1 answer
Drop tables from local database postgres pgadmin
SQL
0 vote197 views1 answer
Netstat -tln mysql
SQL
0 vote206 views1 answer
Mysql sleep connections
SQL
3 votes196 views1 answer
Mysql insert on dupèlicate
SQL
0 vote226 views1 answer
How to fetch data from database in sql
SQL
1 vote201 views1 answer
Cannot define PRIMARY KEY constraint on nullable column in table 'Student'.
SQL
0 vote198 views1 answer
Sum sqlserver
SQL
0 vote217 views2 answers
Mysql show foreign keys
SQL