how to use variable in mysql query code example
Example 1: how to create a variable in mysql
-- MySQL
SET @variable_name := value;
Example 2: how to put value in variable mysql
SET variable = (SELECT SUM(tax) FROM taxable_transactions);
-- MySQL
SET @variable_name := value;
SET variable = (SELECT SUM(tax) FROM taxable_transactions);