declare var on mysql code example
Example 1: how to create a variable in mysql
-- MySQL
SET @variable_name := value;Example 2: mysql declare variable
SET start = 1;
SET finish = 10;
SELECT * FROM places WHERE place BETWEEN start AND finish;-- MySQL
SET @variable_name := value;SET start = 1;
SET finish = 10;
SELECT * FROM places WHERE place BETWEEN start AND finish;