The other types of variables in Java are: byte – stores whole numbers from -128 to 127; short – stores numbers from -32,768 to 32,767; int – stores whole numbers from -2,147,483,648 to ...

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 ...