/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 vote217 views1 answer
Postgres cast as currency format
SQL
4 votes221 views2 answers
How to insert ip address in mysql using php
SQL
19 votes254 views5 answers
Display table in sql
SQL
1 vote239 views1 answer
Sql select all from one table and one column from another
SQL
0 vote221 views1 answer
Trigger value from maltiple table to single table mysql
SQL
0 vote230 views1 answer
Sql server insert inner join
SQL
0 vote227 views1 answer
Mysql changer nom table
SQL
0 vote233 views1 answer
How to login to mysql in homestead
SQL
0 vote258 views1 answer
Sql script to remove default from column
SQL
1 vote233 views1 answer
Mysql select from outside
SQL