Processing intermediate results in MySQL stored procedure -

I try to load a bit of my data using a stored procedure. Basically this means that some columns will be multiplied with their weight and add them to the end.

I have written the following stored procedure:

  Created process (test) BEGIN DECLARE W1 double; DECLARE W2 DOUBLE; DECLARE res1 double; DECLARE res2 double; DECLARE FINAL DOUBLE; Choose weight 1 in weight by weight 1; Choose weight 2 from Weight to Weight 2; 1 Vartable from selection in W1 * Var1 with resize; Selection w2 * var2 to v1.5; Select res1 + resres in res2; Selection Meaning (Refined); END //  

Unfortunately this does not do the trick yet, at the end it should return a value, but all this only works when I put all the wars in the SELECT query I am

You like to output the specified parameters

like

Store the values ​​in the parameter and call this process:

  Call Simple Process (@a);  

and get the price with:

  SELECT @ A;  

This should do the trick