set variable mysql from table value code example Example: how to put value in variable mysql SET variable = (SELECT SUM(tax) FROM taxable_transactions);