字符串中有一个计算公式,我想把他的变量替换后计算出结果,我该如何写SQL语句呢?begin
declare gz DOUBLE(11,2);
declare g1 DOUBLE(11,2);
declare g2 DOUBLE(11,2);
declare content varchar(100); set g1=5;
set g2=6;
set content='g1*5+g2';
gz=???????? //该如何计算后的数值为31 意思是5×5+6
return gz;
end
declare gz DOUBLE(11,2);
declare g1 DOUBLE(11,2);
declare g2 DOUBLE(11,2);
declare content varchar(100); set g1=5;
set g2=6;
set content='g1*5+g2';
gz=???????? //该如何计算后的数值为31 意思是5×5+6
return gz;
end
EXECUTE 'select g1*5+g2 into gz 'USING @g1, @g2
PREPARE stmt2 FROM @s;
set g1=5;
set g2=6;
EXECUTE stmt2 USING @G1, @G2;