how to allot double value to a variable in mysql code example

Example: how to create a variable in mysql

-- MySQL

SET @variable_name := value;