I need to add and multiply variables with columns and show the result with a select will look like the encoding below but because it needs strings, such as "user", and variables of the decimal type select will not work, the coding? Or if the only way to do this is to grab the select values with variables doing the operations and throwing the value into the datagridview without being by select? Visual Studio Community 2017, Mysql Free.
"SELECT *, Sum (Profit * '" variavel01' ") As Total, Sum (Quantity * '" variacomissao "')