Variables in MySQL || How to create user defined variables in MySQL || Leela Soft Vijayawada
#leelasoft
Creation by using a SET statement:
SET @var_name = val;
By using the SELECT statement:
SELECT @var_name;;
SELECT @var_name := value;
MySQL Server supports three types of comments:
1. Starting from a # character to the end of the line
2. Starting from a - - sequence to the end of the line. (double-dash). But after second dash at least one space is required
3. Multi-line comment /* */