Assign a value to a variable in a "SELECT" statement:SELECT @fruit1, @fruit2, @fruit3, @fruit4:='mango';You must use ":=" if you are assigning a value to a variable in any other type of statement ...

You can also use the let statement with a variable name to declare the variable but not define a value for it:. let yVar; In this case, you’ve defined myVar in memory but have yet to assign a ...