Assign value to var in SQL
DECLARE @EmpIDVariable int;
SELECT @EmpIDVariable = MAX(EmployeeID)
FROM HumanResources.Employee;Assign value to var in SQL
DECLARE @EmpIDVariable int;
SELECT @EmpIDVariable = MAX(EmployeeID)
FROM HumanResources.Employee;var in sql
One way of doing this is to use database variables
create table testcalc (
id int(11) not null auto_increment,
num1 int(11) default null,
num2 int(11) default null,
num3 int(11) default null,
num4 int(11) default null,
primary key(id)
);
insert into testcalc values
(default, 1, 2, 3, 4),
(default, 5, 10, 15, 20);
Then you can get the same results as in your example by storing the calculation results in variable syntax like this
@youVar := (calc) as resultName01
Then it will be available to following calculations to use like this
(@youVar + newCalc) as resultName02
We can apply it to your example like this
select
id,
num1,
num2,
num3,
num4,
@1plus2 := (num1 + num2) as 1plus2, # create var01
@1plus2mult3 := (@1plus2 * num3) as 1plus2mult3, # create var02 using var01
@sumOfCalc := (@1plus2 + @1plus2mult3) as sumOfCalc # create var03 using var01 and var02
from testcalc;Copyright © 2021 Codeinu
Forgot your account's password or having trouble logging into your Account? Don't worry, we'll help you to get back your account. Enter your email address and we'll send you a recovery link to reset your password. If you are experiencing problems resetting your password contact us
